Closer to the first one, what I'm exactly looking for is
H1,T1.1 CRLF T1.2 crlf,H2,T2.1 CRLF T2.2 CRLF
While the headings are supposed to be same in all of my files, I.e. they will always appear in the same order, and all of the headings will appear, I know they arn't. So I'm figuring that I'll need to have the heading as part of the record, that way if for example I have something like
H1:
T1.1
T1.2
H3:
T3.1
T3.2
T3.3
I can generate something like:
H1,T1.1 CRLF T1.2 CRLF,H3,T3.1 CRLF T3.2 CRLF T3.3 CRLF
and from that generate...
H1,T1.1 CRLF T1.2 CRLF,H2,,H3,T3.1 CRLF T3.2 CRLF T3.3 CRLF
Since the H2 heading didn't appear in the data, I will have to force in in the final file. I planned this to be a two steep process. I hope that explains things better.
Bentov |