>Hi Masters,
>
>How can I remove the double quatation marks in a field? For example, I have a field called "firstname", and after each record, it comes with a ", like Sam", Eric", John", ect. The file was converted from text format. What command should I use to remove them? I tried to use the command like "REPLACE ALL FIRSTNAME WITH STRTRAN(FIRSTNAME,""",""), but it didn't work. The message error is ")missing". I am using FoxPro 2.6 for Windows. Your help will greatly apprecialted.
>
>I can be reached at szhong@startext.net
>
>Sam Zhong
REPLACE ALL FIRSTNAME WITH STRTRAN(FIRSTNAME,'"',"") should work.
When you use either ' (quote) or " (double quote) as delimitators for char strings in FoxPro.
Vlad
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only