Hi all
I am new to this forum. Here is my problem. I have a log file created by syncsort which looks something like this. The Left and Right are Previous days data file and Current days data file respectively
left source: /u01/filename1
right source: /u01/filename2
records left : 2334
records right: 3345
records paired : 445
records unpaired : 334
I need to gather pick only the information from the right side of the ':' and put it into one string like this with a pipe delimiter '|'
/u01/filename1 | /uo1/filename2 | 2334 | 3345 | 445 | 334
How do I achieve the above using shell scripting. I need to have this in a file and use this file as an input to oracle utility sqlloader to insert the six values into a record in oracle table.
I really appreciate any help in this aspect.
Thanks a lot