Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Append From command craziness
Message
De
18/11/2002 00:13:44
Jordan Pastourel
Worksafe Management Systems
Toowong, Australie
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Append From command craziness
Divers
Thread ID:
00723745
Message ID:
00723745
Vues:
38
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform