>>use table1
>>append from incoming.sdf type sdf for c1="A"
>>use table2
>>append from incoming.sdf type sdf for c1="B"
>>
>>...etc. Unless you have to do this often (whereas this should be in a .prg), you can issue this in the command window.
>Dragan,
>Really cool. Before I never thought I could do this with an SDF data.
>Cetin
Some additional notes to this, from my (seemingly large, but at least long) experience with this type of data manipulation:
- If a row in the sdf file is shorter than the total length of the fields, the remaining fields are blank.
- If it's longer, the remainder of the row is ignored.
- If it contains null bytes, it behaves as if it is shorter, i.e. the remainder of the fields to the right of the null character will be blank.
- Legal line delimiters are cr, lf, crlf, but can't be sure of ff. I remember it misbehaved somehow in some versions of Fox.