Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What is definition of delimited file
Message
From
17/03/1998 17:06:10
 
 
To
17/03/1998 15:05:20
Jerry Tovar
Dana Corporation Dana It
Maumee, Ohio, United States
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00085166
Message ID:
00085211
Views:
28
>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.
Previous
Reply
Map
View

Click here to load this message in the networking platform