Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Converting wierd ASCII file to readable database format
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00215249
Message ID:
00216095
Views:
44
>>test test
>>Also check this line above once in the UT editor and then in preview. It has the same behaviour as your data lines. The delimiter is chr(9) = TAB.
>>
>>>I agree with Nigel. I guess you copied and pasted these 2 lines of data into the UT editor. I see a lot of spaces in the editor in these 2 lines but not in the preview. Thats means there is something other than spaces.
>
>It looks a bit wierd in the UT editor. But trust me. There aren't any delimters in the original file. I can email a piece of the textfile if you want.
>
>I'll try the suggestions Nigel and Paul made.
>
>Thanks!

If there are multiple spaces between the fields, are there multiple spaces inside any fields??

If not you could use FGETS to get the data, and then STRTRAN any multiple spaces with tabs - this will then give you a delimiter (I normally use tabs). You would need to take care of multiple tabs (four spaces=two tabs!!!) this should not be difficult.
Nigel B Coates
NBC Software Services
Dublin, Ireland.
eMail: Nigel.Coates@NBCSoftware.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform