Search Results

Some example data will help to create a solution script for this.

Thanks a lot, this works (When I create a shell script with this content).

Is there any better way to print everything here rather than giving columns like $1,$2 etc, because I have a file having...

I managed to write when I had to make values null in the last column:

awk -v numLines=`cat data.out.20090526 | wc -l` 'BEGIN { FS=OFS="|" } {if(NR > 1 && NR < numLines) {$4="null"} } 1'...

Hi

I have a file, with format like:

column1|coulumn2|column3|column4
A|X|K|18
L|O|R|31,42,25
G|H|I|55,66
L|E|Q|25,31,94

output required:

column1|coulumn2|column3|column4
A|X|K|18...