Shell Programming and Scripting

Hi all, I'm new at forum, I cant find an answer to my problem so ,

I need a file which has pipe as a file separator and I need to add a column to a file in the third column I write this code but it s not enough ,

cat allproblems | nawk'\

BEGIN { FS:"|" } {print $3 $4 $5, ????} '

-------------------------

This prints the concataneted 3,4 and 5th columns but I want to add it to second field which is already exist so before it was shifted second to third ..

Thank you all your patient.

Can you please explain your requirement with an example.

My file :AAAA|BBBBBBBBBB|CCCCCC|DDDD|EEEEEE 5 field

To : AAAA|BBBBBBBBBB CCCCCC CCCCCC|BBBBBBBBBB|CCCCCC|DDDD|EEEEEE 6 fiekd

Is that clarify a little bit more ?

Should be something like:

Code:

awk -F"|" '{$2="BBBBBBBBBB CCCCCC CCCCCC|" $2}1' OFS="|" allproblems

May be this is what you need...

Code:

awk -F"|" '{OFS="|"}{$2=$2" "$3" "$3;print $0}' inputfile

Thank you all but I'm wondering the function of OFS="|"

My code :

cat all | nawk' BEGIN{ FS="|"} { $5=$3" "$4" "$NR; print $0}' > allnew

There are not any pipes at allnew file.. They were disappeared. ( because OFS ??? )

OFS==Output field separator, use it if you want records to be separated.