Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Importing From CSV files not so simple
Message
De
30/05/2007 14:31:55
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
 
 
À
30/05/2007 13:55:03
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Divers
Thread ID:
01228989
Message ID:
01229410
Vues:
15
>Well yes, but I've never had a firm grasp on exactly what I'm seeing in files except for CR and LF's. I've looked at various editors including the sample tool that came with fox but didn't think they were very intuitive.
>
>At your suggestion however, I did some searching and found a really cool one
>called XVI32 which I really like and it's time I learn it.
>
>Thank you. -Rick
>
>Edit: Usinv XVI32 it was incredibly simple to figure this out. Thanks again.


In cases like this (i.e. a weird text format) I usually look for the beginning and end of a known piece of text. In your case, it'd be the shortest memo which contains line breaks. Since Excel can consume it, I figure the line breaks within the memo are probably different from the line breaks at the end of records (say, just LFs vs CRLFs), and whatever the separators (apostrophes, maybe, or tabs?) are used to surround the memo are not to be found inside the memos or are escaped somehow. Once you know what you're up against, you can slice your records.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform