How to generate file from a awk variable

[rrs123]

Hello,

I have a csv file just like bellow.

"filename1","d1","d2","d3","d4",
"filename1","d1","d2","d3","d4",
"filename1","d1","d2","d3","d4",
"filename2","d1","d2","d3","d4",
"filename2","d1","d2","d3","d4",
"filename2","d1","d2","d3","d4",

What I would like to create two files filename1 and filename2 as follow.

filename1:
"d1","d2","d3","d4",
"d1","d2","d3","d4",
"d1","d2","d3","d4",
filename2:
"d1","d2","d3","d4",
"d1","d2","d3","d4",
"d1","d2","d3","d4",

How could I do ut using awk?

Thanks in advance

RS

 

[PHV]

awk -F'"' '{out=$2;x=$0;sub(/[^,]*,/,"",x);print x>out}' /path/to/input.csv

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886