I have a text file like this:
20201117125512HH 001APPOINTMENT DATA 85372
APTHDR0350100000001 1 2CROS04202020-11-25012020-11-25 15:30:00.000000 PIC077120 128027 2020-11-17 12:50:52.000265 N N 0000004390000000000186000000 00000 PIC077120 023095412
APTDTL035010000000C116780360635000000439PIC077120 023095412
APTHDR0350100000001 1 2CACG05002020-11-25012020-11-25 14:00:00.000000 3501382191/, 183699 2020-11-17 12:51:02.000864 N Y NS0000013210083300043754000000 00000 3501382191/, 1621476023035082
APTDTL035010000000C3100203821910000010013501382191/, 1621476023035082
APTDTL035010000000C3100202566840000001003501382191/, 1621476023035082
APTDTL035010000000C3100203826550000001073501382191/, 1621476023035082
APTDTL035010000000C3100203852630000000203501382191/, 1621476023035082
APTDTL035010000000C3100203746790000000183501382191/, 1621476023035082
APTDTL035010000000C3100202903510000000753501382191/, 1621476023035082
20201117125512TT 001000000000000000000110000000000
i need to transform to schema with some conditions:
- with the first line and last line: just ignore them.
- with the line start with "APTHDR": it's the header data, need to split the data by position
- with the line start with "APTDTL": it is the detail data of the header before it, need to split the data by position. i need to transform that file to xml (schema) by biztalk, xslt or logic apps. for now i don't how is that possible to do that?
You guys have any idea or any guys know about that can help me? thanks you guys so much.