Want to populate double quotes for each filed using awk:

Input: cat file.txt => "1-23-test_test1-test2"

Required output :

"1-23-test_test1-test2"|"#GT_properties_xyz"

Was trying the below command on solaris 9 machine :

awk -F"|" '{print $1"|""#GT_properties_xyz"}' file.txt

If you want literal quotes in there, put literal quotes in there, escaped with \ so awk won't take them to be the start/end of its own strings.

awk -v OFS='|' '{ $2="\"#GT_properties_xyz\"" } 1' file.txt

Thanks, but if one is dealing with 5 or 6 data inputs/field seperators. ex: if the below is the required output :


"1-23-test_test1-test2"|"#GT_properties_xyz"|"test1"|"1000"|"LAST"

---------- Post updated at 12:19 AM ---------- Previous update was at 12:11 AM ----------

Thanks, but if one is dealing with 5 or 6 data inputs/field seperators. ex: if the below is the required output :


"1-23-test_test1-test2"|"#GT_properties_xyz"|"test1"|"1000"|"LAST"

Don't bump posts.

If that's the output you want, what's the input you had?

awk -F'|' -v OFS='|' '{ $(NF+1)="\"#GT_properties_xyz\"" } 1' file.txt

Input: cat file.txt => "1-23-test_test1-test2"

Required output :

"1-23-test_test1-test2"|"#GT_properties_xyz"|"test1"|"1000"|"LAST"

Okay. awk will let you cheat and put two columns in one column, so:

awk -F'|' -v OFS="|" '{ $1=$1 FS "\"#GT_properties_xyz\"|\"test\"|\"1000\"|\"LAST\"" } 1' filename

Seems some problem with the syntax, command not working:

Code:

bash-2.05$ awk -F'|' -v OFS="|" '{ $1=$1 FS "\"#GT_properties_xyz\"|\"test\"|\"1000\"|\"LAST\"" } 1' file.txt
awk: syntax error near line 1
awk: bailing out near line 1
bash-2.05$