Add prefix backslash and quotes to comma separated columns in shell script

Question

Need to convert the below string to add prefix backslash and suffix backslash for comma separated columns. String values can be dynamic values (some times we get two comma separated values or three comma separated values ..etc)

Thanks for your help

var="ABC,BCD,EFG,ZYZ,XYZ,ADF"

output : \"ABC\",\"BCD\",\"EFG\",\"ZYZ\",\"XYZ\",\"ADF\"

Yes, three upper case letters. yes, it can be empty. yes values contain commans — user2358844, Oct 19 '20 at 14:20

score 0 · Answer 1 · answered Oct 19 '20 at 03:47

0

echo "$var" | sed 's;\([A-Z]\{3\}\);\\"\1\\";g'
\"ABC\",\"BCD\",\"EFG\",\"ZYZ\",\"XYZ\",\"ADF\"

answered Oct 19 '20 at 03:47

schrodingerscatcuriosity

12,396

Thanks for your help . I need to assign output value into another variable. I am getting an errror. pr= echo "$var" | sed 's;$[A-Z]\{3\}$;\\"\1\\";g' echo$pr – user2358844 Oct 20 '20 at 05:54
Look up command substitution: pr=$(echo "$var" | sed 's;$[A-Z]\{3\}$;\\"\1\\";g'). – schrodingerscatcuriosity Oct 20 '20 at 07:50
The command you posted is missing backslashses in the parenthesis, and there must not be spaces between the ssignment: pr=$(... – schrodingerscatcuriosity Oct 20 '20 at 07:51

Add prefix backslash and quotes to comma separated columns in shell script

1 Answers1