Mixing
Awk - replace one character only in a certain column
7
I have a file like this:
2018.01.02;1.5;comment 1
2018.01.04;2.75;comment 2
2018.01.07;5.25;comment 4
2018.01.09;1.25;comment 7
I want to replace all dots . in the second column with a comma , as I would with sed 's/./,/g' file how can I use sed or preferably awk to only apply this for the second column, so my output would look like this:
2018.01.02;1,5;comment 1
2018.01.04;2,75;comment 2
2018.01.07;5,25;comment 4
2018.01.09;1,25;comment 7
text-processing awk sed
asked Jan 4 at 15:14
nathnath
937625
add a comment |
7
I have a file like this:
2018.01.02;1.5;comment 1
2018.01.04;2.75;comment 2
2018.01.07;5.25;comment 4
2018.01.09;1.25;comment 7
I want to replace all dots . in the second column with a comma , as I would with sed 's/./,/g' file how can I use sed or preferably awk to only apply this for the second column, so my output would look like this:
2018.01.02;1,5;comment 1
2018.01.04;2,75;comment 2
2018.01.07;5,25;comment 4
2018.01.09;1,25;comment 7
text-processing awk sed
asked Jan 4 at 15:14
nathnath
937625
add a comment |
7
7
7
I have a file like this:
2018.01.02;1.5;comment 1
2018.01.04;2.75;comment 2
2018.01.07;5.25;comment 4
2018.01.09;1.25;comment 7
I want to replace all dots . in the second column with a comma , as I would with sed 's/./,/g' file how can I use sed or preferably awk to only apply this for the second column, so my output would look like this:
2018.01.02;1,5;comment 1
2018.01.04;2,75;comment 2
2018.01.07;5,25;comment 4
2018.01.09;1,25;comment 7
text-processing awk sed
asked Jan 4 at 15:14
nathnath
937625
I have a file like this:
2018.01.02;1.5;comment 1
2018.01.04;2.75;comment 2
2018.01.07;5.25;comment 4
2018.01.09;1.25;comment 7
I want to replace all dots . in the second column with a comma , as I would with sed 's/./,/g' file how can I use sed or preferably awk to only apply this for the second column, so my output would look like this:
2018.01.02;1,5;comment 1
2018.01.04;2,75;comment 2
2018.01.07;5,25;comment 4
2018.01.09;1,25;comment 7
text-processing awk sed
text-processing awk sed
asked Jan 4 at 15:14
nathnath
937625
asked Jan 4 at 15:14
nathnath
937625
asked Jan 4 at 15:14
nathnath
937625
asked Jan 4 at 15:14
nathnath
937625
asked Jan 4 at 15:14
nathnath
937625
937625
add a comment |
add a comment |
3 Answers
3
active
oldest
votes
15
$ awk 'BEGIN{FS=OFS=";"} {gsub(/./, ",", $2)} 1' ip.txt
2018.01.02;1,5;comment 1
2018.01.04;2,75;comment 2
2018.01.07;5,25;comment 4
2018.01.09;1,25;comment 7
BEGIN{}this block of code will be executed before processing any input line
FS=OFS=";"set input and output field separator as;
gsub(/./, ",", $2)for each input line, replace all the.in 2nd field with,
1is an awk idiom to print contents of$0(which contains the input record)
answered Jan 4 at 15:18
SundeepSundeep
7,4011927
1
awesome, much THX!
– nath
Jan 4 at 15:19
add a comment |
7
sed 's/./,/3' file
replace the third occurence of the dot
answered Jan 4 at 15:20
Emilio GalarragaEmilio Galarraga
50929
2
Another Useles Use ofcat... Why not justsed 's/./,/3' file? (Also, the comma does not need to be escaped.)
– twalberg
Jan 4 at 15:42
I took into account the observations
– Emilio Galarraga
Jan 4 at 15:54
catwould not necessarily be useless here. It would allow the operation to use 2 cores.
– ron rothman ℝℝ
Jan 5 at 1:40
add a comment |
4
Done by below method using awk
Command: awk -F ";" '{gsub(/./,",",$2);print $1";"$2";"$3}' filename
output
2018.01.02;1,5;comment 1
2018.01.04;2,75;comment 2
2018.01.07;5,25;comment 4
2018.01.09;1,25;comment 7
answered Jan 4 at 16:36
Praveen Kumar BSPraveen Kumar BS
1,346138
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "106"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2funix.stackexchange.com%2fquestions%2f492500%2fawk-replace-one-character-only-in-a-certain-column%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
3 Answers
3
active
oldest
votes
3 Answers
3
active
oldest
votes
active
oldest
votes
active
oldest
votes
15
$ awk 'BEGIN{FS=OFS=";"} {gsub(/./, ",", $2)} 1' ip.txt
2018.01.02;1,5;comment 1
2018.01.04;2,75;comment 2
2018.01.07;5,25;comment 4
2018.01.09;1,25;comment 7
BEGIN{}this block of code will be executed before processing any input line
FS=OFS=";"set input and output field separator as;
gsub(/./, ",", $2)for each input line, replace all the.in 2nd field with,
1is an awk idiom to print contents of$0(which contains the input record)
answered Jan 4 at 15:18
SundeepSundeep
7,4011927
1
awesome, much THX!
– nath
Jan 4 at 15:19
add a comment |
15
$ awk 'BEGIN{FS=OFS=";"} {gsub(/./, ",", $2)} 1' ip.txt
2018.01.02;1,5;comment 1
2018.01.04;2,75;comment 2
2018.01.07;5,25;comment 4
2018.01.09;1,25;comment 7
BEGIN{}this block of code will be executed before processing any input line
FS=OFS=";"set input and output field separator as;
gsub(/./, ",", $2)for each input line, replace all the.in 2nd field with,
1is an awk idiom to print contents of$0(which contains the input record)
answered Jan 4 at 15:18
SundeepSundeep
7,4011927
1
awesome, much THX!
– nath
Jan 4 at 15:19
add a comment |
15
15
15
$ awk 'BEGIN{FS=OFS=";"} {gsub(/./, ",", $2)} 1' ip.txt
2018.01.02;1,5;comment 1
2018.01.04;2,75;comment 2
2018.01.07;5,25;comment 4
2018.01.09;1,25;comment 7
BEGIN{}this block of code will be executed before processing any input line
FS=OFS=";"set input and output field separator as;
gsub(/./, ",", $2)for each input line, replace all the.in 2nd field with,
1is an awk idiom to print contents of$0(which contains the input record)
answered Jan 4 at 15:18
SundeepSundeep
7,4011927
$ awk 'BEGIN{FS=OFS=";"} {gsub(/./, ",", $2)} 1' ip.txt
2018.01.02;1,5;comment 1
2018.01.04;2,75;comment 2
2018.01.07;5,25;comment 4
2018.01.09;1,25;comment 7
BEGIN{}this block of code will be executed before processing any input line
FS=OFS=";"set input and output field separator as;
gsub(/./, ",", $2)for each input line, replace all the.in 2nd field with,
1is an awk idiom to print contents of$0(which contains the input record)
answered Jan 4 at 15:18
SundeepSundeep
7,4011927
edited Jan 4 at 15:20
answered Jan 4 at 15:18
SundeepSundeep
7,4011927
answered Jan 4 at 15:18
SundeepSundeep
7,4011927
answered Jan 4 at 15:18
SundeepSundeep
7,4011927
7,4011927
1
awesome, much THX!
– nath
Jan 4 at 15:19
add a comment |
1
awesome, much THX!
– nath
Jan 4 at 15:19
1
1
awesome, much THX!
– nath
Jan 4 at 15:19
awesome, much THX!
– nath
Jan 4 at 15:19
add a comment |
7
sed 's/./,/3' file
replace the third occurence of the dot
answered Jan 4 at 15:20
Emilio GalarragaEmilio Galarraga
50929
2
Another Useles Use ofcat... Why not justsed 's/./,/3' file? (Also, the comma does not need to be escaped.)
– twalberg
Jan 4 at 15:42
I took into account the observations
– Emilio Galarraga
Jan 4 at 15:54
catwould not necessarily be useless here. It would allow the operation to use 2 cores.
– ron rothman ℝℝ
Jan 5 at 1:40
add a comment |
7
sed 's/./,/3' file
replace the third occurence of the dot
answered Jan 4 at 15:20
Emilio GalarragaEmilio Galarraga
50929
2
Another Useles Use ofcat... Why not justsed 's/./,/3' file? (Also, the comma does not need to be escaped.)
– twalberg
Jan 4 at 15:42
I took into account the observations
– Emilio Galarraga
Jan 4 at 15:54
catwould not necessarily be useless here. It would allow the operation to use 2 cores.
– ron rothman ℝℝ
Jan 5 at 1:40
add a comment |
7
7
7
sed 's/./,/3' file
replace the third occurence of the dot
answered Jan 4 at 15:20
Emilio GalarragaEmilio Galarraga
50929
sed 's/./,/3' file
replace the third occurence of the dot
answered Jan 4 at 15:20
Emilio GalarragaEmilio Galarraga
50929
edited Jan 4 at 15:51
answered Jan 4 at 15:20
Emilio GalarragaEmilio Galarraga
50929
answered Jan 4 at 15:20
Emilio GalarragaEmilio Galarraga
50929
answered Jan 4 at 15:20
Emilio GalarragaEmilio Galarraga
50929
50929
2
Another Useles Use ofcat... Why not justsed 's/./,/3' file? (Also, the comma does not need to be escaped.)
– twalberg
Jan 4 at 15:42
I took into account the observations
– Emilio Galarraga
Jan 4 at 15:54
catwould not necessarily be useless here. It would allow the operation to use 2 cores.
– ron rothman ℝℝ
Jan 5 at 1:40
add a comment |
2
Another Useles Use ofcat... Why not justsed 's/./,/3' file? (Also, the comma does not need to be escaped.)
– twalberg
Jan 4 at 15:42
I took into account the observations
– Emilio Galarraga
Jan 4 at 15:54
catwould not necessarily be useless here. It would allow the operation to use 2 cores.
– ron rothman ℝℝ
Jan 5 at 1:40
2
2
Another Useles Use of
cat... Why not just sed 's/./,/3' file? (Also, the comma does not need to be escaped.)– twalberg
Jan 4 at 15:42
Another Useles Use of
cat... Why not just sed 's/./,/3' file? (Also, the comma does not need to be escaped.)– twalberg
Jan 4 at 15:42
I took into account the observations
– Emilio Galarraga
Jan 4 at 15:54
I took into account the observations
– Emilio Galarraga
Jan 4 at 15:54
cat would not necessarily be useless here. It would allow the operation to use 2 cores.– ron rothman ℝℝ
Jan 5 at 1:40
cat would not necessarily be useless here. It would allow the operation to use 2 cores.– ron rothman ℝℝ
Jan 5 at 1:40
add a comment |
4
Done by below method using awk
Command: awk -F ";" '{gsub(/./,",",$2);print $1";"$2";"$3}' filename
output
2018.01.02;1,5;comment 1
2018.01.04;2,75;comment 2
2018.01.07;5,25;comment 4
2018.01.09;1,25;comment 7
answered Jan 4 at 16:36
Praveen Kumar BSPraveen Kumar BS
1,346138
add a comment |
4
Done by below method using awk
Command: awk -F ";" '{gsub(/./,",",$2);print $1";"$2";"$3}' filename
output
2018.01.02;1,5;comment 1
2018.01.04;2,75;comment 2
2018.01.07;5,25;comment 4
2018.01.09;1,25;comment 7
answered Jan 4 at 16:36
Praveen Kumar BSPraveen Kumar BS
1,346138
add a comment |
4
4
4
Done by below method using awk
Command: awk -F ";" '{gsub(/./,",",$2);print $1";"$2";"$3}' filename
output
2018.01.02;1,5;comment 1
2018.01.04;2,75;comment 2
2018.01.07;5,25;comment 4
2018.01.09;1,25;comment 7
answered Jan 4 at 16:36
Praveen Kumar BSPraveen Kumar BS
1,346138
Done by below method using awk
Command: awk -F ";" '{gsub(/./,",",$2);print $1";"$2";"$3}' filename
output
2018.01.02;1,5;comment 1
2018.01.04;2,75;comment 2
2018.01.07;5,25;comment 4
2018.01.09;1,25;comment 7
answered Jan 4 at 16:36
Praveen Kumar BSPraveen Kumar BS
1,346138
answered Jan 4 at 16:36
Praveen Kumar BSPraveen Kumar BS
1,346138
answered Jan 4 at 16:36
Praveen Kumar BSPraveen Kumar BS
1,346138
answered Jan 4 at 16:36
Praveen Kumar BSPraveen Kumar BS
1,346138
1,346138
add a comment |
add a comment |
draft saved
draft discarded
Thanks for contributing an answer to Unix & Linux Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2funix.stackexchange.com%2fquestions%2f492500%2fawk-replace-one-character-only-in-a-certain-column%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
