Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Parsing a file that's not quite comma-delimited
Message
From
11/07/2007 13:35:49
 
 
To
11/07/2007 11:13:08
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 8 SP1
Miscellaneous
Thread ID:
01238841
Message ID:
01239396
Views:
18
This message has been marked as a message which has helped to the initial question of the thread.
Cetin,

I haven't followed closely, but to assume almost nothing on the order of lines I'ld code
FOR ix=1 TO alines(laLines,m.lcSample)
   = alines(laFields, Alltrim(Str(m.ix)) + "|" + laLines[m.ix])
   Insert into ("Curs_" + Alltrim(laFields[2]) ) from Array laFields
endfor
after having created the correctly named and structured tables/Cursors "Curs_MSH", "Curs_EVH" and so on for each line type with a sequential number corresponding to the original line number already thrown in. No need to mess with field/property names at all.

Perhaps at the end throw in one replace and possibly even one alter table for each whole table.
But I am too lazy too type much <g>

regards

thomas
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform