Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Csv
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Re: Csv
Miscellaneous
Thread ID:
00663248
Message ID:
00663254
Views:
11
It looks like the problem is those two contiguous quotes in the data. You probably need to convert that before you try to append it. Here some code to try (untested):
lcBadStuff = FileToStr('OrigFile')
lcGoodStuff = StrTran(lcBadStuff,[""],[])
StrToFile(lcGoodStuff, "Newfile")
Then, you can append from the new file.

>I have a work file(CSV) created from a process and I am trying to append it into a cursor. Here is the issue. The work file looks like this
>
>"Cust#","CustName","Address"
>"12345","Smith","123 Street"
>"12346","Joe""smith","3 Street"
>
>After appending my cursor looks like this
>
>12345,Smith,123 Street
>12346,Joe,smith
>
>I need the cursor to be like this
>
>12345,Smith,123 Street
>12346,Joe"smith,3 Street
>
>How can I get this. I am using append from delimited command to append.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform