Shell Programming and Scripting

I am trying to create a new CSV file from an existing CSV file whose content is as follows:

"1","Tom,Garry","111"
"2","Tom,Garry","222"

when i use Cat file | cut -d',' -f1,3 or awk to have only the 1st and 3rd column in my new CSV file, instead of creating a file content as
"1","111"
"2","222"

It is creating as
"1",Garry"
"2",Garry"

This is because of the comma in the second field.
Could you please help me how to sort it out.

$cat file | cut -d'"' -f2,6 | tr -s '"' ','
1,111
2,222

Or maybe...

Code:

awk 'BEGIN{OFS=FS="\",\""}{print $1,$3}' file

Code:

 sed -e 's_\("[^"]*"\),.*,\("[^"]*"\)_\1,\2_g' input.txt

You broke the rules when you started this thread.

(4) Do not 'bump up' questions if they are not answered promptly. No duplicate or cross-posting and do not report a post where your goal is to get an answer more quickly.

Your thread - Deleting specific columns from a file

Edit: Darn Ygor beat me !

Hi Rahul I am very new to unix/shell scripting...I thank you for ur reply..
But my problem is :because of the comma in the second field "Tom,Garry" of my original file, the cut command when i cut based on comma splits this second field into two fields.

it is considering
"1" as 1st field
"Tom as 2nd filed
Garry" as 3rd field
"111" as 4th field

But i want
"1" as 1st field
"Tom,Garry" as 2nd filed
"111" as third field

so when i try to move 1st and 3rd column to a new file,it is moving the 1st and the second part of second column to the new file..

Hi Guys sorry if i have violated the rules.Since my issue now has changed to a different one I created a new thread. Previously I had issue with cuting the columns in file and now my issue is about comma delimiter.
In some of other forums I have seen rules to create a new thread if our topic changes. Thats the reason I created a new thread.And this is my first thread.so I am unaware of the rules here..sorry..

Premar,

The baisc idea of a delimiter is to have such a character as a field separator such that it does not appear in data. Thus while the file is created, it needs to be made sure that ',' will not be a part of the data or else you should use another delimiter.