Search Results

Thanks

IF the file is already sorted on the three columns , can the remove duplicate part be a little simpler , I wanted to use this code in a datastage program , and was wondering if the code...

How do we sort and remove duplicate on column 1,2 retaining the record with maximum date (in feild 3) for the file with following format.


aaa|1234|2010-12-31
aaa|1234|2010-11-10...

Thank you all for the responses ,
I tried the following , an it provides the required output .

awk 'BEGIN {FS="|"} {n=split($3,a,";");for (i=1;i<=n;i++) { print n FS $1 FS $2 FS a[i] } }'...

Hi

Please suggest a script that would do a horizontal pivot , on the fields separated by a semicolon
Below is my input file 1|c2|aa
1|c3|dd
1|c4|cc
1|c5|aa
1|c6|ss
1|c7|dd
1|c8|bb...

sed -n 's#\(.*\)\\.*#\1#p' myFile
The above code gives me PCI\Image test\ out of the string PCI\Image test\Batch::I0Main ,
How can I ge the last part in Batch::I0Main.

Sorry not pretty good at...