change only part of the substring using sed

up vote
3
down vote

favorite

I have a file that contains a numbers copied from somewhere. It looks something like this:

02 12 04 01 07 10 11 06 08 05 03 15 13 00 14 09,
14 11 02 12 04 07 13 01 05 00 15 10 03 09 08 06,
04 02 01 11 10 13 07 08 15 09 12 05 06 03 00 14,
11 08 12 07 01 14 02 13 06 15 00 09 10 04 05 03

I now have to add comma after every number (basically to make it a C++ array) but as you can see it can be very tedious to do, especially if you have many of them.

I tried using sed like:
cat file.txt | sed -r "s/ /, /g"

But if I use this I am going to replace every "space" with ',space' and I only want to replace spaces that come after a digit with ','

If I use cat file.txt | sed -r "s/[0123456789] /, /g", I won't be able to get the same number before replacement. Thus, I only want to change some part of the substring.

How do I do this?

edited 10 mins ago

GAD3R

23k164896

asked 2 hours ago

scipsycho

182

New contributor

1

@Hello scipsycho. Please see below. is this what you want?
â€“Â Goro
2 hours ago

add a commentÂ |Â

up vote
3
down vote

favorite

I have a file that contains a numbers copied from somewhere. It looks something like this:

02 12 04 01 07 10 11 06 08 05 03 15 13 00 14 09,
14 11 02 12 04 07 13 01 05 00 15 10 03 09 08 06,
04 02 01 11 10 13 07 08 15 09 12 05 06 03 00 14,
11 08 12 07 01 14 02 13 06 15 00 09 10 04 05 03

I now have to add comma after every number (basically to make it a C++ array) but as you can see it can be very tedious to do, especially if you have many of them.

I tried using sed like:
cat file.txt | sed -r "s/ /, /g"

But if I use this I am going to replace every "space" with ',space' and I only want to replace spaces that come after a digit with ','

If I use cat file.txt | sed -r "s/[0123456789] /, /g", I won't be able to get the same number before replacement. Thus, I only want to change some part of the substring.

How do I do this?

edited 10 mins ago

GAD3R

23k164896

asked 2 hours ago

scipsycho

182

New contributor

1

@Hello scipsycho. Please see below. is this what you want?
â€“Â Goro
2 hours ago

add a commentÂ |Â

up vote
3
down vote

favorite

I have a file that contains a numbers copied from somewhere. It looks something like this:

02 12 04 01 07 10 11 06 08 05 03 15 13 00 14 09,
14 11 02 12 04 07 13 01 05 00 15 10 03 09 08 06,
04 02 01 11 10 13 07 08 15 09 12 05 06 03 00 14,
11 08 12 07 01 14 02 13 06 15 00 09 10 04 05 03

I now have to add comma after every number (basically to make it a C++ array) but as you can see it can be very tedious to do, especially if you have many of them.

I tried using sed like:
cat file.txt | sed -r "s/ /, /g"

But if I use this I am going to replace every "space" with ',space' and I only want to replace spaces that come after a digit with ','

If I use cat file.txt | sed -r "s/[0123456789] /, /g", I won't be able to get the same number before replacement. Thus, I only want to change some part of the substring.

How do I do this?

edited 10 mins ago

GAD3R

23k164896

asked 2 hours ago

scipsycho

182

New contributor

I have a file that contains a numbers copied from somewhere. It looks something like this:

02 12 04 01 07 10 11 06 08 05 03 15 13 00 14 09,
14 11 02 12 04 07 13 01 05 00 15 10 03 09 08 06,
04 02 01 11 10 13 07 08 15 09 12 05 06 03 00 14,
11 08 12 07 01 14 02 13 06 15 00 09 10 04 05 03

I now have to add comma after every number (basically to make it a C++ array) but as you can see it can be very tedious to do, especially if you have many of them.

I tried using sed like:
cat file.txt | sed -r "s/ /, /g"

But if I use this I am going to replace every "space" with ',space' and I only want to replace spaces that come after a digit with ','

If I use cat file.txt | sed -r "s/[0123456789] /, /g", I won't be able to get the same number before replacement. Thus, I only want to change some part of the substring.

How do I do this?

sed

edited 10 mins ago

GAD3R

23k164896

asked 2 hours ago

scipsycho

182

New contributor

edited 10 mins ago

GAD3R

23k164896

asked 2 hours ago

scipsycho

182

New contributor

edited 10 mins ago

GAD3R

23k164896

edited 10 mins ago

GAD3R

23k164896

edited 10 mins ago

GAD3R

23k164896

asked 2 hours ago

scipsycho

182

New contributor

asked 2 hours ago

scipsycho

182

asked 2 hours ago

scipsycho

182

New contributor

scipsycho is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

1

@Hello scipsycho. Please see below. is this what you want?
â€“Â Goro
2 hours ago

add a commentÂ |Â

1

@Hello scipsycho. Please see below. is this what you want?
â€“Â Goro
2 hours ago

@Hello scipsycho. Please see below. is this what you want?
â€“Â Goro
2 hours ago

add a commentÂ |Â

4 Answers
4

active

oldest

votes

up vote
3
down vote

accepted

cat file.txt | sed -r 's/([0-9]+)/1,/g'

02, 12, 04, 01, 07, 10, 11, 06, 08, 05, 03, 15, 13, 00, 14, 09,,
14, 11, 02, 12, 04, 07, 13, 01, 05, 00, 15, 10, 03, 09, 08, 06,,
04, 02, 01, 11, 10, 13, 07, 08, 15, 09, 12, 05, 06, 03, 00, 14,,
11, 08, 12, 07, 01, 14, 02, 13, 06, 15, 00, 09, 10, 04, 05, 03,

Explanation:

First capturing group ([0-9]+)

Match a single character (i.e. number) present in the table [0-9]+ 
+ Quantifier Ã¢Â€Â” Matches between one and unlimited times, as many times as possible, giving back as needed (greedy)
0-9 a single character in the range between 0 (index 48) and 9 (index 57) (case sensitive)

In other words, the [0-9]+ pattern matches an integer number (without decimals) even Inside longer strings, even words.
1 is called a "back reference" or "special escapes" in the sed documentation. It refers to the corresponding matching sub-expressions in the regexp. In other words, in this example, it inserts the contents of each captured number in the table followed by comma.

edited 2 hours ago

answered 2 hours ago

Goro

4,85552358

1

Thanks! it worked! What does this '1' mean?
â€“Â scipsycho
2 hours ago

Hi @scipsycho. ` 1` refers to the number within each cell in the field will be followed by a comma. :-)
â€“Â Goro
2 hours ago

So, those brackets tell sed what to include in '1', right?
â€“Â scipsycho
2 hours ago

1

Hi @Goro, thanks a lot for this explanation.
â€“Â scipsycho
2 hours ago

1

The 1 is called a "back reference" in the sed documentation.
â€“Â RobertL
2 hours ago

Â |Â
show 1 more comment

up vote
1
down vote

You can just replace a space followed by any number of spaces by a comma:

sed 's/ */,/g' file

(if the spaces at the start of some lines are just a copy paste error)

answered 2 hours ago

choroba

24.8k34168

add a commentÂ |Â

up vote
1
down vote

How about

sed 's/ +/, /g' file
02, 12, 04, 01, 07, 10, 11, 06, 08, 05, 03, 15, 13, 00, 14, 09,
14, 11, 02, 12, 04, 07, 13, 01, 05, 00, 15, 10, 03, 09, 08, 06,
04, 02, 01, 11, 10, 13, 07, 08, 15, 09, 12, 05, 06, 03, 00, 14,
11, 08, 12, 07, 01, 14, 02, 13, 06, 15, 00, 09, 10, 04, 05, 03

answered 2 hours ago

RudiC

1,3999

add a commentÂ |Â

up vote
1
down vote

This perl command will add a comma in between a digit and a space

perl -pe 's/(?<=d)(?=s)/,/g' file

answered 1 hour ago

glenn jackman

48.1k365105

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',
convertImagesToLinks: false,
noModals: false,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);

);

scipsycho is a new contributor. Be nice, and check out our Code of Conduct.

draft saved

draft discarded

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2funix.stackexchange.com%2fquestions%2f471875%2fchange-only-part-of-the-substring-using-sed%23new-answer', 'question_page');

);

Post as a guest

Name

4 Answers
4

active

oldest

votes

4 Answers
4

active

oldest

votes

up vote
3
down vote

accepted

cat file.txt | sed -r 's/([0-9]+)/1,/g'

02, 12, 04, 01, 07, 10, 11, 06, 08, 05, 03, 15, 13, 00, 14, 09,,
14, 11, 02, 12, 04, 07, 13, 01, 05, 00, 15, 10, 03, 09, 08, 06,,
04, 02, 01, 11, 10, 13, 07, 08, 15, 09, 12, 05, 06, 03, 00, 14,,
11, 08, 12, 07, 01, 14, 02, 13, 06, 15, 00, 09, 10, 04, 05, 03,

Explanation:

First capturing group ([0-9]+)

Match a single character (i.e. number) present in the table [0-9]+ 
+ Quantifier Ã¢Â€Â” Matches between one and unlimited times, as many times as possible, giving back as needed (greedy)
0-9 a single character in the range between 0 (index 48) and 9 (index 57) (case sensitive)

In other words, the [0-9]+ pattern matches an integer number (without decimals) even Inside longer strings, even words.
1 is called a "back reference" or "special escapes" in the sed documentation. It refers to the corresponding matching sub-expressions in the regexp. In other words, in this example, it inserts the contents of each captured number in the table followed by comma.

edited 2 hours ago

answered 2 hours ago

Goro

4,85552358

1

Thanks! it worked! What does this '1' mean?
â€“Â scipsycho
2 hours ago

Hi @scipsycho. ` 1` refers to the number within each cell in the field will be followed by a comma. :-)
â€“Â Goro
2 hours ago

So, those brackets tell sed what to include in '1', right?
â€“Â scipsycho
2 hours ago

1

Hi @Goro, thanks a lot for this explanation.
â€“Â scipsycho
2 hours ago

1

The 1 is called a "back reference" in the sed documentation.
â€“Â RobertL
2 hours ago

Â |Â
show 1 more comment

up vote
3
down vote

accepted

cat file.txt | sed -r 's/([0-9]+)/1,/g'

02, 12, 04, 01, 07, 10, 11, 06, 08, 05, 03, 15, 13, 00, 14, 09,,
14, 11, 02, 12, 04, 07, 13, 01, 05, 00, 15, 10, 03, 09, 08, 06,,
04, 02, 01, 11, 10, 13, 07, 08, 15, 09, 12, 05, 06, 03, 00, 14,,
11, 08, 12, 07, 01, 14, 02, 13, 06, 15, 00, 09, 10, 04, 05, 03,

Explanation:

First capturing group ([0-9]+)

Match a single character (i.e. number) present in the table [0-9]+ 
+ Quantifier Ã¢Â€Â” Matches between one and unlimited times, as many times as possible, giving back as needed (greedy)
0-9 a single character in the range between 0 (index 48) and 9 (index 57) (case sensitive)

In other words, the [0-9]+ pattern matches an integer number (without decimals) even Inside longer strings, even words.
1 is called a "back reference" or "special escapes" in the sed documentation. It refers to the corresponding matching sub-expressions in the regexp. In other words, in this example, it inserts the contents of each captured number in the table followed by comma.

edited 2 hours ago

answered 2 hours ago

Goro

4,85552358

1

Thanks! it worked! What does this '1' mean?
â€“Â scipsycho
2 hours ago

Hi @scipsycho. ` 1` refers to the number within each cell in the field will be followed by a comma. :-)
â€“Â Goro
2 hours ago

So, those brackets tell sed what to include in '1', right?
â€“Â scipsycho
2 hours ago

1

Hi @Goro, thanks a lot for this explanation.
â€“Â scipsycho
2 hours ago

1

The 1 is called a "back reference" in the sed documentation.
â€“Â RobertL
2 hours ago

Â |Â
show 1 more comment

up vote
3
down vote

accepted

cat file.txt | sed -r 's/([0-9]+)/1,/g'

02, 12, 04, 01, 07, 10, 11, 06, 08, 05, 03, 15, 13, 00, 14, 09,,
14, 11, 02, 12, 04, 07, 13, 01, 05, 00, 15, 10, 03, 09, 08, 06,,
04, 02, 01, 11, 10, 13, 07, 08, 15, 09, 12, 05, 06, 03, 00, 14,,
11, 08, 12, 07, 01, 14, 02, 13, 06, 15, 00, 09, 10, 04, 05, 03,

Explanation:

First capturing group ([0-9]+)

Match a single character (i.e. number) present in the table [0-9]+ 
+ Quantifier Ã¢Â€Â” Matches between one and unlimited times, as many times as possible, giving back as needed (greedy)
0-9 a single character in the range between 0 (index 48) and 9 (index 57) (case sensitive)

In other words, the [0-9]+ pattern matches an integer number (without decimals) even Inside longer strings, even words.
1 is called a "back reference" or "special escapes" in the sed documentation. It refers to the corresponding matching sub-expressions in the regexp. In other words, in this example, it inserts the contents of each captured number in the table followed by comma.

edited 2 hours ago

answered 2 hours ago

Goro

4,85552358

cat file.txt | sed -r 's/([0-9]+)/1,/g'

02, 12, 04, 01, 07, 10, 11, 06, 08, 05, 03, 15, 13, 00, 14, 09,,
14, 11, 02, 12, 04, 07, 13, 01, 05, 00, 15, 10, 03, 09, 08, 06,,
04, 02, 01, 11, 10, 13, 07, 08, 15, 09, 12, 05, 06, 03, 00, 14,,
11, 08, 12, 07, 01, 14, 02, 13, 06, 15, 00, 09, 10, 04, 05, 03,

Explanation:

First capturing group ([0-9]+)

Match a single character (i.e. number) present in the table [0-9]+ 
+ Quantifier Ã¢Â€Â” Matches between one and unlimited times, as many times as possible, giving back as needed (greedy)
0-9 a single character in the range between 0 (index 48) and 9 (index 57) (case sensitive)

In other words, the [0-9]+ pattern matches an integer number (without decimals) even Inside longer strings, even words.
1 is called a "back reference" or "special escapes" in the sed documentation. It refers to the corresponding matching sub-expressions in the regexp. In other words, in this example, it inserts the contents of each captured number in the table followed by comma.

edited 2 hours ago

answered 2 hours ago

Goro

4,85552358

edited 2 hours ago

answered 2 hours ago

Goro

4,85552358

answered 2 hours ago

Goro

4,85552358

answered 2 hours ago

Goro

4,85552358

1

Thanks! it worked! What does this '1' mean?
â€“Â scipsycho
2 hours ago

Hi @scipsycho. ` 1` refers to the number within each cell in the field will be followed by a comma. :-)
â€“Â Goro
2 hours ago

So, those brackets tell sed what to include in '1', right?
â€“Â scipsycho
2 hours ago

1

Hi @Goro, thanks a lot for this explanation.
â€“Â scipsycho
2 hours ago

1

The 1 is called a "back reference" in the sed documentation.
â€“Â RobertL
2 hours ago

Â |Â
show 1 more comment

1

Thanks! it worked! What does this '1' mean?
â€“Â scipsycho
2 hours ago

Hi @scipsycho. ` 1` refers to the number within each cell in the field will be followed by a comma. :-)
â€“Â Goro
2 hours ago

So, those brackets tell sed what to include in '1', right?
â€“Â scipsycho
2 hours ago

1

Hi @Goro, thanks a lot for this explanation.
â€“Â scipsycho
2 hours ago

1

The 1 is called a "back reference" in the sed documentation.
â€“Â RobertL
2 hours ago

Thanks! it worked! What does this '1' mean?
â€“Â scipsycho
2 hours ago

Hi @scipsycho. ` 1` refers to the number within each cell in the field will be followed by a comma. :-)
â€“Â Goro
2 hours ago

So, those brackets tell sed what to include in '1', right?
â€“Â scipsycho
2 hours ago

Hi @Goro, thanks a lot for this explanation.
â€“Â scipsycho
2 hours ago

The 1 is called a "back reference" in the sed documentation.
â€“Â RobertL
2 hours ago

Â |Â
show 1 more comment

up vote
1
down vote

You can just replace a space followed by any number of spaces by a comma:

sed 's/ */,/g' file

(if the spaces at the start of some lines are just a copy paste error)

answered 2 hours ago

choroba

24.8k34168

add a commentÂ |Â

up vote
1
down vote

You can just replace a space followed by any number of spaces by a comma:

sed 's/ */,/g' file

(if the spaces at the start of some lines are just a copy paste error)

answered 2 hours ago

choroba

24.8k34168

add a commentÂ |Â

up vote
1
down vote

You can just replace a space followed by any number of spaces by a comma:

sed 's/ */,/g' file

(if the spaces at the start of some lines are just a copy paste error)

answered 2 hours ago

choroba

24.8k34168

You can just replace a space followed by any number of spaces by a comma:

sed 's/ */,/g' file

(if the spaces at the start of some lines are just a copy paste error)

answered 2 hours ago

choroba

24.8k34168

answered 2 hours ago

choroba

24.8k34168

answered 2 hours ago

choroba

24.8k34168

answered 2 hours ago

choroba

24.8k34168

add a commentÂ |Â

up vote
1
down vote

How about

sed 's/ +/, /g' file
02, 12, 04, 01, 07, 10, 11, 06, 08, 05, 03, 15, 13, 00, 14, 09,
14, 11, 02, 12, 04, 07, 13, 01, 05, 00, 15, 10, 03, 09, 08, 06,
04, 02, 01, 11, 10, 13, 07, 08, 15, 09, 12, 05, 06, 03, 00, 14,
11, 08, 12, 07, 01, 14, 02, 13, 06, 15, 00, 09, 10, 04, 05, 03

answered 2 hours ago

RudiC

1,3999

add a commentÂ |Â

up vote
1
down vote

How about

sed 's/ +/, /g' file
02, 12, 04, 01, 07, 10, 11, 06, 08, 05, 03, 15, 13, 00, 14, 09,
14, 11, 02, 12, 04, 07, 13, 01, 05, 00, 15, 10, 03, 09, 08, 06,
04, 02, 01, 11, 10, 13, 07, 08, 15, 09, 12, 05, 06, 03, 00, 14,
11, 08, 12, 07, 01, 14, 02, 13, 06, 15, 00, 09, 10, 04, 05, 03

answered 2 hours ago

RudiC

1,3999

add a commentÂ |Â

up vote
1
down vote

How about

sed 's/ +/, /g' file
02, 12, 04, 01, 07, 10, 11, 06, 08, 05, 03, 15, 13, 00, 14, 09,
14, 11, 02, 12, 04, 07, 13, 01, 05, 00, 15, 10, 03, 09, 08, 06,
04, 02, 01, 11, 10, 13, 07, 08, 15, 09, 12, 05, 06, 03, 00, 14,
11, 08, 12, 07, 01, 14, 02, 13, 06, 15, 00, 09, 10, 04, 05, 03

answered 2 hours ago

RudiC

1,3999

How about

sed 's/ +/, /g' file
02, 12, 04, 01, 07, 10, 11, 06, 08, 05, 03, 15, 13, 00, 14, 09,
14, 11, 02, 12, 04, 07, 13, 01, 05, 00, 15, 10, 03, 09, 08, 06,
04, 02, 01, 11, 10, 13, 07, 08, 15, 09, 12, 05, 06, 03, 00, 14,
11, 08, 12, 07, 01, 14, 02, 13, 06, 15, 00, 09, 10, 04, 05, 03

answered 2 hours ago

RudiC

1,3999

answered 2 hours ago

RudiC

1,3999

answered 2 hours ago

RudiC

1,3999

answered 2 hours ago

RudiC

1,3999

add a commentÂ |Â

up vote
1
down vote

This perl command will add a comma in between a digit and a space

perl -pe 's/(?<=d)(?=s)/,/g' file

answered 1 hour ago

glenn jackman

48.1k365105

add a commentÂ |Â

up vote
1
down vote

This perl command will add a comma in between a digit and a space

perl -pe 's/(?<=d)(?=s)/,/g' file

answered 1 hour ago

glenn jackman

48.1k365105

add a commentÂ |Â

up vote
1
down vote

This perl command will add a comma in between a digit and a space

perl -pe 's/(?<=d)(?=s)/,/g' file

answered 1 hour ago

glenn jackman

48.1k365105

This perl command will add a comma in between a digit and a space

perl -pe 's/(?<=d)(?=s)/,/g' file

answered 1 hour ago

glenn jackman

48.1k365105

answered 1 hour ago

glenn jackman

48.1k365105

answered 1 hour ago

glenn jackman

48.1k365105

answered 1 hour ago

glenn jackman

48.1k365105

add a commentÂ |Â

scipsycho is a new contributor. Be nice, and check out our Code of Conduct.

draft saved

draft discarded

scipsycho is a new contributor. Be nice, and check out our Code of Conduct.

draft saved

draft discarded

Post as a guest

Name

Search This Blog

Iyfjky