>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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement