Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Converting wierd ASCII file to readable database format
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00215249
Message ID:
00216095
Vues:
43
>>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform