How can I increment a numerical part of a string between two characters using sed or awk or grep?

Question

I have a string like X1.7_RC02.20170811110948 and I need to increase only the number between RC and the next point, example:

Original string:

X1.7_RC02.20170811110948

Incremented string:

X1.7_RC03.20170811110948

How can I increase in 1 (or more this value)?

Possible duplicate of [How to find/replace and increment a matched number with sed/awk?](https://stackoverflow.com/questions/14348432/how-to-find-replace-and-increment-a-matched-number-with-sed-awk) — Wiktor Stribiżew, Aug 11 '17 at 09:23

Ed Morton · Answer 1 · 2017-08-11T10:21:23.897

4

with GNU awk for the 3rd arg to match():

$ awk 'match($0,/(.*RC)([^.]+)(.*)/,a){$0=sprintf("%s%02d%s",a[1],a[2]+1,a[3])} 1' file
X1.7_RC03.20170811110948

edited Aug 11 '17 at 10:21

answered Aug 11 '17 at 09:41

Ed Morton

score 2 · Accepted Answer · answered Aug 11 '17 at 10:44

2

With GNU sed

sed -r 's/(.*)(RC0?)([1-9]+)(\..*)/echo "\1\2$((\3+1))\4"/e' <<<X1.7_RC02.20170811110948

answered Aug 11 '17 at 10:44

Paul

score 1 · Answer 3 · answered Aug 11 '17 at 09:28

Considering your data is same as shown example then try with following awk once too and let me know if this helps you.

awk '{val=$0;gsub(/.*RC|\..*/,"",val);val=sprintf("%02d",++val);sub(/RC[0-2]+/,"RC"val);print}'  Input_file

Or if you have a string then you could print it's value and could run above command like:

echo "$var" | awk '{val=$0;gsub(/.*RC|\..*/,"",val);val=sprintf("%02d",++val);sub(/RC[0-2]+/,"RC"val);print}'

score 1 · Answer 4 · answered Aug 11 '17 at 09:35

1

awk solution:

Initial string:

s="X1.7_RC02.20170811110948"

awk 'BEGIN{ FS=OFS="_RC"}{ n=substr($2,1,2); print $1,sprintf("%02.f",n+1) substr($2,3)}' <<< $s

The output:

X1.7_RC03.20170811110948

answered Aug 11 '17 at 09:35

RomanPerekhrest

4 Answers4