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

Click here to load this message in the networking platform