File formatting query
Posted: Mon Jul 02, 2012 9:50 pm
Input file:
This input file is pipe delimited. We want to create the output file in below format.
Output File:
The fields which are coming after DTS# can come in next 300 lines. In present case it is coming in 2 lines.
Is there anyway to get file formated in this way. Please suggest. Any help is greatly appreciated. Let me know if you want more info.
HDR|DISP|20120628|DTS|TAXI|0001|
DTS|DISP|1234567890122| 2000000|P|Y|20120627| |
DTS|NOTE|1234567890122|DTS1 |PERM | 1|20120627|DTS#
2000000. This is a sample note. AS3807
|
TRL| 4|
DTS|DISP|1234567890122| 2000000|P|Y|20120627| |
DTS|NOTE|1234567890122|DTS1 |PERM | 1|20120627|DTS#
2000000. This is a sample note. AS3807
|
TRL| 4|
This input file is pipe delimited. We want to create the output file in below format.
Output File:
HDR|DISP|20120628|DTS|TAXI|0001|
DTS|DISP|1234567890122| 2000000|P|Y|20120627| |
DTS|NOTE|1234567890122|DTS1 |PERM | 1|20120627|DTS#2000000. This is a sample note. AS3807|
TRL| 4|
DTS|DISP|1234567890122| 2000000|P|Y|20120627| |
DTS|NOTE|1234567890122|DTS1 |PERM | 1|20120627|DTS#2000000. This is a sample note. AS3807|
TRL| 4|
The fields which are coming after DTS# can come in next 300 lines. In present case it is coming in 2 lines.
Is there anyway to get file formated in this way. Please suggest. Any help is greatly appreciated. Let me know if you want more info.