Hi All,
I have space delimited file similar to the one as shown below.. I need to convert it as a pipe delimited, the values inside the pipe delimited file should be as highlighted...
AA ATIU[COLOR="Red"]2345[/COLOR]0[COLOR="rgb(255, 0, 255)"]98[/COLOR][COLOR="Lime"]809[/COLOR] 00[COLOR="Cyan"]969[/COLOR]7 00[COLOR="Yellow"]537[/COLOR]4
BB ATIU[COLOR="red"]2345[/COLOR]0[COLOR="rgb(255, 0, 255)"]97[/COLOR][COLOR="lime"]809[/COLOR] 00[COLOR="Cyan"]544[/COLOR]5 00[COLOR="yellow"]651[/COLOR]8
CC ATIU[COLOR="red"]9685[/COLOR]0[COLOR="rgb(255, 0, 255)"]98[/COLOR][COLOR="lime"]809[/COLOR] 00[COLOR="rgb(0, 255, 255)"]321[/COLOR]5 00[COLOR="yellow"]357[/COLOR]1
DD ATIU[COLOR="red"]9685[/COLOR]0[COLOR="rgb(255, 0, 255)"]98[/COLOR][COLOR="lime"]709[/COLOR] 00[COLOR="rgb(0, 255, 255)"]687[/COLOR]8 00[COLOR="yellow"]234[/COLOR]4
EE ATIU[COLOR="red"]2315[/COLOR]0[COLOR="rgb(255, 0, 255)"]98[/COLOR][COLOR="lime"]809[/COLOR] 00[COLOR="rgb(0, 255, 255)"]564[/COLOR]9 00[COLOR="yellow"]537[/COLOR]7
FF ATIU[COLOR="red"]2315[/COLOR]0[COLOR="rgb(255, 0, 255)"]98[/COLOR][COLOR="lime"]809[/COLOR] 00[COLOR="rgb(0, 255, 255)"]523[/COLOR]1 00[COLOR="yellow"]535[/COLOR]4
TT TTT TTT
I want to convert this file into a pipe delimited file as shown below without including the last row in the above file(ie TT TTT TTT),
[COLOR="Red"]2345[/COLOR]|[COLOR="Magenta"]98[/COLOR]|[COLOR="lime"]809[/COLOR]||x|[COLOR="Cyan"]969[/COLOR]|0
[COLOR="red"]2345[/COLOR]|[COLOR="rgb(255, 0, 255)"]97[/COLOR]|[COLOR="lime"]809[/COLOR]||x|[COLOR="rgb(0, 255, 255)"]544[/COLOR]|0
[COLOR="red"]2345[/COLOR]|[COLOR="rgb(255, 0, 255)"]98[/COLOR]|[COLOR="lime"]809[/COLOR]||y|0|[COLOR="yellow"]537[/COLOR]
[COLOR="red"]2345[/COLOR]|[COLOR="rgb(255, 0, 255)"]97[/COLOR]|[COLOR="lime"]809[/COLOR]||y|0|[COLOR="yellow"]651[/COLOR]
[COLOR="red"]9685[/COLOR]|[COLOR="rgb(255, 0, 255)"]98[/COLOR]|[COLOR="lime"]809[/COLOR]||x|[COLOR="rgb(0, 255, 255)"]321[/COLOR]|0
[COLOR="red"]9685[/COLOR]|[COLOR="rgb(255, 0, 255)"]98[/COLOR]|[COLOR="lime"]809[/COLOR]||x|[COLOR="rgb(0, 255, 255)"]687[/COLOR]|0
[COLOR="red"]9685[/COLOR]|[COLOR="rgb(255, 0, 255)"]98[/COLOR]|[COLOR="lime"]709[/COLOR]||y|0|[COLOR="yellow"]357[/COLOR]
[COLOR="red"]9685[/COLOR]|[COLOR="rgb(255, 0, 255)"]98[/COLOR]|[COLOR="lime"]709[/COLOR]||y|0|[COLOR="yellow"]234[/COLOR]
[COLOR="red"]2315[/COLOR]|[COLOR="rgb(255, 0, 255)"]98[/COLOR]|[COLOR="lime"]809[/COLOR]||x|[COLOR="rgb(0, 255, 255)"]564[/COLOR]|0
[COLOR="red"]2315[/COLOR]|[COLOR="rgb(255, 0, 255)"]98[/COLOR]|[COLOR="lime"]809[/COLOR]||x|[COLOR="rgb(0, 255, 255)"]523[/COLOR]|0
[COLOR="red"]2315[/COLOR]|[COLOR="rgb(255, 0, 255)"]98[/COLOR]|[COLOR="lime"]809[/COLOR]||y|0|[COLOR="yellow"]537[/COLOR]
[COLOR="red"]2315[/COLOR]|[COLOR="rgb(255, 0, 255)"]98[/COLOR]|[COLOR="lime"]809[/COLOR]||y|0|[COLOR="Yellow"]535[/COLOR]