>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
If everything is regular (order of fields do not change etc) it'd be easy:) However there are other messages saying that this is an HL7 format (which I don't know the details) the situation might be much more complex than it looks.
Cetin