Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Parsing a file that's not quite comma-delimited
Message
De
10/07/2007 10:51:57
Jay Johengen
Altamahaw-Ossipee, Caroline du Nord, États-Unis
 
 
À
10/07/2007 10:41:47
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 8 SP1
Divers
Thread ID:
01238841
Message ID:
01238909
Vues:
19
>>>Sorry but delimiter flag wouldn't help you. Go lowlevel.
>>>Cetin
>>
>>That's too cryptic for me. Why can't I can't I append using the "|" delimiter and then insert into the appropriate cursors based on the identifiers? Is that a bad approach? The data is actually going to be in a memory variable, but I should be able to simulate the same thing.
>
>Given the format you specified it'd be a bad approach. In that format:
>1) There are multiple tables wrapped with identifiers (you could solve this one easily).
>2) The data length between delimiters are not compatible with 'append from'. Some are over 254 in length I guess (not checked explicitly). You need to get them into memo fields. If you go with append from, then you need to make multiple passes (one type SDF with too many fields) to make sure you didn't leave unprocessed data behind.
>
>Be it in a memory variable or on disk, you could lowlevel process it and deliver to multiple tables, parsing on the fly. I have alraday seen a specific pattern so it wouldn't hard to be parse:
>
>-Identifers for target table
>-"|" as field delimiter
>-"^" highly probable is a placeholder for inline CRLF.
>-Each record ending with a CRLF
>
>You can do this in pure VFP or with help from SQL server to bulk load into MSSQL tables first and then export to VFP.
>Cetin

I guess I need you to define what you mean by LowLevel then.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform