Replace commas for strings enclosed double quotes [duplicate]
Multi tool use
Clash Royale CLAN TAG#URR8PPP
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty margin-bottom:0;
up vote
0
down vote
favorite
This question already has an answer here:
Remove comma between the quotes only in a comma delimited file
7 answers
Remove only the commas present within the double quotes
4 answers
I have a line, that looks like this.
Das,Dwda,3145124,4,"7,5",6,"7,5",6,8,7,51,"5,5",10,17,"83,5"
I want to change all commas inside double quotes to a period with some command in bash like awk or sed.
bash awk sed
asked Jul 19 at 9:08
Mladia
454
marked as duplicate by Kusalananda bash
Users with the  bash badge can single-handedly close bash questions as duplicates and reopen them as needed.
StackExchange.ready(function()
if (StackExchange.options.isMobile) return;
$('.dupe-hammer-message-hover:not(.hover-bound)').each(function()
var $hover = $(this).addClass('hover-bound'),
$msg = $hover.siblings('.dupe-hammer-message');
$hover.hover(
function()
$hover.showInfoMessage('',
messageElement: $msg.clone().show(),
transient: false,
position: my: 'bottom left', at: 'top center', offsetTop: -7 ,
dismissable: false,
relativeToBody: true
);
,
function()
StackExchange.helpers.removeMessages();
);
);
);
Jul 19 at 9:18
This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.
add a comment |Â
up vote
0
down vote
favorite
This question already has an answer here:
Remove comma between the quotes only in a comma delimited file
7 answers
Remove only the commas present within the double quotes
4 answers
I have a line, that looks like this.
Das,Dwda,3145124,4,"7,5",6,"7,5",6,8,7,51,"5,5",10,17,"83,5"
I want to change all commas inside double quotes to a period with some command in bash like awk or sed.
bash awk sed
asked Jul 19 at 9:08
Mladia
454
marked as duplicate by Kusalananda bash
Users with the  bash badge can single-handedly close bash questions as duplicates and reopen them as needed.
StackExchange.ready(function()
if (StackExchange.options.isMobile) return;
$('.dupe-hammer-message-hover:not(.hover-bound)').each(function()
var $hover = $(this).addClass('hover-bound'),
$msg = $hover.siblings('.dupe-hammer-message');
$hover.hover(
function()
$hover.showInfoMessage('',
messageElement: $msg.clone().show(),
transient: false,
position: my: 'bottom left', at: 'top center', offsetTop: -7 ,
dismissable: false,
relativeToBody: true
);
,
function()
StackExchange.helpers.removeMessages();
);
);
);
Jul 19 at 9:18
This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.
1
what did you try so far? The two top-most related answers are pretty close.
– RoVo
Jul 19 at 9:13
Also note that after replacing commas with dots, the quotes are no longer needed in CSV.
– choroba
Jul 19 at 9:21
Yes, that I am aware, but removing the quotes is easy. Right now I am struggling to understand thissed -r ':a;s/(("[0-9,]*",?)*"[0-9,]*),/1/;ta; s/""/","/g;, which was a top comment from another answer, but I am not sure how to adapt that, not to remove the commas, but to replace the comma with a dot EDIT: didn't copy the whole line
– Mladia
Jul 19 at 9:33
add a comment |Â
up vote
0
down vote
favorite
up vote
0
down vote
favorite
This question already has an answer here:
Remove comma between the quotes only in a comma delimited file
7 answers
Remove only the commas present within the double quotes
4 answers
I have a line, that looks like this.
Das,Dwda,3145124,4,"7,5",6,"7,5",6,8,7,51,"5,5",10,17,"83,5"
I want to change all commas inside double quotes to a period with some command in bash like awk or sed.
bash awk sed
asked Jul 19 at 9:08
Mladia
454
This question already has an answer here:
Remove comma between the quotes only in a comma delimited file
7 answers
Remove only the commas present within the double quotes
4 answers
I have a line, that looks like this.
Das,Dwda,3145124,4,"7,5",6,"7,5",6,8,7,51,"5,5",10,17,"83,5"
I want to change all commas inside double quotes to a period with some command in bash like awk or sed.
This question already has an answer here:
Remove comma between the quotes only in a comma delimited file
7 answers
Remove only the commas present within the double quotes
4 answers
bash awk sed
asked Jul 19 at 9:08
Mladia
454
asked Jul 19 at 9:08
Mladia
454
asked Jul 19 at 9:08
Mladia
454
asked Jul 19 at 9:08
Mladia
454
454
marked as duplicate by Kusalananda bash
Users with the  bash badge can single-handedly close bash questions as duplicates and reopen them as needed.
StackExchange.ready(function()
if (StackExchange.options.isMobile) return;
$('.dupe-hammer-message-hover:not(.hover-bound)').each(function()
var $hover = $(this).addClass('hover-bound'),
$msg = $hover.siblings('.dupe-hammer-message');
$hover.hover(
function()
$hover.showInfoMessage('',
messageElement: $msg.clone().show(),
transient: false,
position: my: 'bottom left', at: 'top center', offsetTop: -7 ,
dismissable: false,
relativeToBody: true
);
,
function()
StackExchange.helpers.removeMessages();
);
);
);
Jul 19 at 9:18
This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.
marked as duplicate by Kusalananda bash
Users with the  bash badge can single-handedly close bash questions as duplicates and reopen them as needed.
StackExchange.ready(function()
if (StackExchange.options.isMobile) return;
$('.dupe-hammer-message-hover:not(.hover-bound)').each(function()
var $hover = $(this).addClass('hover-bound'),
$msg = $hover.siblings('.dupe-hammer-message');
$hover.hover(
function()
$hover.showInfoMessage('',
messageElement: $msg.clone().show(),
transient: false,
position: my: 'bottom left', at: 'top center', offsetTop: -7 ,
dismissable: false,
relativeToBody: true
);
,
function()
StackExchange.helpers.removeMessages();
);
);
);
Jul 19 at 9:18
This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.
1
what did you try so far? The two top-most related answers are pretty close.
– RoVo
Jul 19 at 9:13
Also note that after replacing commas with dots, the quotes are no longer needed in CSV.
– choroba
Jul 19 at 9:21
Yes, that I am aware, but removing the quotes is easy. Right now I am struggling to understand thissed -r ':a;s/(("[0-9,]*",?)*"[0-9,]*),/1/;ta; s/""/","/g;, which was a top comment from another answer, but I am not sure how to adapt that, not to remove the commas, but to replace the comma with a dot EDIT: didn't copy the whole line
– Mladia
Jul 19 at 9:33
add a comment |Â
1
what did you try so far? The two top-most related answers are pretty close.
– RoVo
Jul 19 at 9:13
Also note that after replacing commas with dots, the quotes are no longer needed in CSV.
– choroba
Jul 19 at 9:21
Yes, that I am aware, but removing the quotes is easy. Right now I am struggling to understand thissed -r ':a;s/(("[0-9,]*",?)*"[0-9,]*),/1/;ta; s/""/","/g;, which was a top comment from another answer, but I am not sure how to adapt that, not to remove the commas, but to replace the comma with a dot EDIT: didn't copy the whole line
– Mladia
Jul 19 at 9:33
1
1
what did you try so far? The two top-most related answers are pretty close.
– RoVo
Jul 19 at 9:13
what did you try so far? The two top-most related answers are pretty close.
– RoVo
Jul 19 at 9:13
Also note that after replacing commas with dots, the quotes are no longer needed in CSV.
– choroba
Jul 19 at 9:21
Also note that after replacing commas with dots, the quotes are no longer needed in CSV.
– choroba
Jul 19 at 9:21
Yes, that I am aware, but removing the quotes is easy. Right now I am struggling to understand this
sed -r ':a;s/(("[0-9,]*",?)*"[0-9,]*),/1/;ta; s/""/","/g; , which was a top comment from another answer, but I am not sure how to adapt that, not to remove the commas, but to replace the comma with a dot EDIT: didn't copy the whole line– Mladia
Jul 19 at 9:33
Yes, that I am aware, but removing the quotes is easy. Right now I am struggling to understand this
sed -r ':a;s/(("[0-9,]*",?)*"[0-9,]*),/1/;ta; s/""/","/g; , which was a top comment from another answer, but I am not sure how to adapt that, not to remove the commas, but to replace the comma with a dot EDIT: didn't copy the whole line– Mladia
Jul 19 at 9:33
add a comment |Â
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
1
what did you try so far? The two top-most related answers are pretty close.
– RoVo
Jul 19 at 9:13
Also note that after replacing commas with dots, the quotes are no longer needed in CSV.
– choroba
Jul 19 at 9:21
Yes, that I am aware, but removing the quotes is easy. Right now I am struggling to understand this
sed -r ':a;s/(("[0-9,]*",?)*"[0-9,]*),/1/;ta; s/""/","/g;, which was a top comment from another answer, but I am not sure how to adapt that, not to remove the commas, but to replace the comma with a dot EDIT: didn't copy the whole line– Mladia
Jul 19 at 9:33