String manipulation problem

Shell Programming and Scripting
1

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

2

Assume the log is named "logfile.log"

I'm sure there's a way to simplify my way. I welcome any improvements:

cut -f3- -d ' ' logfile.log | sed 's/://;s/[ \t]*//' | awk '{output = output $1 " | "} END {print output}' > logdata.dat
3

RESULT_STR=`awk -F":" '{printf $2 " | "}' $LOG_FILE`

4

Hahaha -- now that's just embarrasing. :wink:

Good job