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
Jordan Pastourel
Development Manager