Remove quotes in awk command

Question

I have a text file that needs to be processed using awk.

"5","1211274723","0","D","2"
"1","1211292921","0","A","2"
"5","1211295793","0","A","2"
"5","1211310146","0","A","2"
"5","1211310310","0","A","2"
"4","1211315271","0","A","2"
"5","1211318203","0","D","2"
"2","1211323658","0","A","2"
"5","1211329224","0","A","2"
"5","1211330064","0","A","2"


# cat testme.csv | awk -F',' '{print "set", $2, $3}'
set "1211274723" "0"
set "1211292921" "0"
set "1211295793" "0"
set "1211310146" "0"
set "1211310310" "0"
set "1211315271" "0"
set "1211318203" "0"
set "1211323658" "0"
set "1211329224" "0"
set "1211330064" "0"

The only problem is that I do not know how to remove the quotes around phone numbers. So that my final output will look something like this...

set 1211274723 "0"
set 1211292921 "0"
set 1211295793 "0"
set 1211310146 "0"
set 1211310310 "0"
set 1211315271 "0"
set 1211318203 "0"
set 1211323658 "0"
set 1211329224 "0"
set 1211330064 "0"

score 74 · Accepted Answer · answered Oct 20 '13 at 07:16

74

You can use gsub function:

awk -F',' '{gsub(/"/, "", $2); print "set", $2, $3}' testme.csv 
set 1211274723 "0"
set 1211292921 "0"
set 1211295793 "0"
set 1211310146 "0"
set 1211310310 "0"
set 1211315271 "0"
set 1211318203 "0"
set 1211323658 "0"
set 1211329224 "0"
set 1211330064 "0"

answered Oct 20 '13 at 07:16

anubhava

761,203
64
569
643

Do you know how to convert csv to tsv using `awk`? quotes also should be removed. – Pramodya Mendis Apr 27 '20 at 17:25
1

`awk 'BEGIN { FS=","; OFS="\t" } {gsub(/"/, "");$1=$1; print}' ../task2/sample.csv > sample.tsv ` This worked, Thanks – Pramodya Mendis Apr 27 '20 at 17:28

perreal · Answer 2 · 2013-10-20T07:25:18.067

26

Using double quotes as the field separator;

 awk -F'"' '{print "set", $4, "\""$6"\""}' testme.csv

edited Oct 20 '13 at 07:25

answered Oct 20 '13 at 07:16

perreal

94,503
21
155
181

An answer in the pure KISS principle for a "can't see the forest for the trees" situation. You sir get a point just for this :). – Lohmar ASHAR Jan 20 '21 at 20:45

Remove quotes in awk command

2 Answers2