awk -F'^"|","|"$' '{ OFS="|" ; print $2,$3,$4 }' somefile.txt
Use awk to parse a comma delimited file.
OFS=”|” outputs to a pipe delimited file.
Add one to all column references, $1 = $2, $2 = $3, etc.
awk -F'^"|","|"$' '{ OFS="|" ; print $2,$3,$4 }' somefile.txt
Use awk to parse a comma delimited file.
OFS=”|” outputs to a pipe delimited file.
Add one to all column references, $1 = $2, $2 = $3, etc.
