Shell Programming and Scripting

ok, got it.

It will trim all the spaces between the columns.

i tried with same data and same command,not trimming the spaces. Help me

I followed the below post.

@Birei,it tried with your command,not trimming 2,4 and 10..
Help me.

Ok. Why don't we do things right, then?

1.- I put two scripts, one in 'perl' and other in 'awk'. Which of those don't work?
2.- I tested my own scripts and they seem to work with the data provided by you. Are you testing with similar data or not?
3.- Paste your input data you are testing, put the script you are running and the output it gives, or the error description.

I know a little about programming but can not read minds for the moment. Some users gave a solution and none of them seem to work, so think if we all are mistaken or perhaps you are not explaining your problem correctly , so try to help us a little bit, please. Thank you.

Regards,
Birei.

@Birei, Please below one... Perl script is working fine....

Code:

-bash-3.2$ awk 'BEGIN { FS = OFS = "|" } { for ( i = 1; i <= NF; i++ ) { if ( i == 2 || i == 4 || i == 10 ) { sub( /^\s*/, "", $i ); sub( /\s*$/, "", $i ) } } { print } }' test1.txt
CCNI | data564_input1 | 264 |CCNI| data564_input1 |264
ccni| data564_input1
CORO1A| 155

@bmk:

Which version of 'awk'?

In my machine works but I use the GNU version, and perhaps other don't support the withespace character regex '\s'. Try with a simple space, like:

$ awk 'BEGIN { FS = OFS = "|" } { for ( i = 1; i <= NF; i++ ) { if ( i == 2 || i == 4 || i == 10 ) { sub( /^ */, "", $i ); sub( / *$/, "", $i ) } } { print } }' infile

Regards,
Birei