Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Append From command craziness
Message
 
 
To
18/11/2002 00:13:44
Jordan Pastourel
Worksafe Management Systems
Toowong, Australia
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00723745
Message ID:
00723746
Views:
18
If file is not too big, and there is a character, which never occurs in the file, say, ^, you can try:

strtofile(strtran(filetostr(myFile),["],[^]),MyNewFile)
and then append and lately do a replace.

Or write to the file using low-level functions...

>Hi all,
>i am having a bit of a problem with the Append From command. Here is the issue:
>i create a cursor to match the format of a .csv file (field delimited by , and character delimited by ")
>
>i then use the append from command to put the data into a foxpro table:
>append from &fileclaim delimited
>
>all seemed to go well for a while until i realised that within some of the character fields there were statements like "there was a 6" gap". with the " after the 6 "gap" moves onto the next field and stuffs up all the rest of the record with the fields all moved along one.
>
>is there a way around this without writing my own append routine? i can't change the output of the file i am appending either as it comes as is from another company. i also tried stating explicitly the delimiters as:
>append from &fileclaim delimited with " with character ,
>didn't help :(
>
>please help,
>Jordan
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform