Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
What is definition of delimited file
Message
De
17/03/1998 17:06:10
 
 
À
17/03/1998 15:05:20
Jerry Tovar
Dana Corporation Dana It
Maumee, Ohio, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00085166
Message ID:
00085211
Vues:
24
>Does anybdy know where I can get the "Offical" definition of delimited ascii files?
>
>We are working with another one of our divisions and the guys there keep sending us comma delimited files. Normally this is OK, but in this case, some of the fields have double quotes in the data and it messes up the data when we APPEND FROM TYPE DELIMITED.
>
>They are downloading this data from a mainframe into an ascii file for us.
>
>We would like them to send us an SDF file, but they claim that this is a "Standard Delimited File".
>
>Is there any site that has definition of what the different delimited files types are?
>
>Thanks,
>
>Jerry Tovar

You may also try to remove the quotes from your text files with:

CREATE CURSOR temp (dummy m) && Cursor with dummy memo field
APPEND BLANK
APPEND MEMO dummy FROM sdffile.txt
REPLACE temp.dummy WITH STRTRAN(temp.dummy, '"','')
COPY MEMO dummy TO mytext.txt

I believe I saw a thread not long ago where they mentioned having problems with populating memo fields with big text files. Anyway, hope this helps.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform