How to Split quote-comma delimeted file in unix

[flower45]

Hi,

I have a file like

"aa","bb",'123"
"aa,a","cc","234"

I want cut column 3 which is 123 and 234. any help regading is greately appreciated. How i can use awk commant to perform above operation

Thanks in advance

 

[Annihilannic]

Try this:

awk -F '[green]^"|","|"$[/green]' '{[b]print[/b] [blue]$4[/blue]}' inputfile > outputfile

Note that this assumes that every field is surrounded by quotes; if that's not the case it gets a little more complicated.

Annihilannic.

 

[Ogzilal]

If your column is the last in the file and if you have "rev command" installed
reverse twice

rev /path/to/file | awk -F"," '{print $1}' |rev

and then remove " and ' using sed tr or your favorite tool