string - Increase numbers in file using sed and regexp

Question

I want to increase all numbers in file by 1000 with follow pattern:

'... comment_count') VALUES ( 15132, ...
'... comment_count') VALUES ( 15133, ...
'... comment_count') VALUES ( 16134, ...
.
.

I want after change output be like this:

'... comment_count') VALUES ( 16132, ...
'... comment_count') VALUES ( 16133, ...
'... comment_count') VALUES ( 17134, ...
.
.

I tried something like this but not work:

 sed -r 's/`comment_count`) VALUES ( (d+)/echo "11$((1+1000))"/ge'  test.txt 

Answer 1

sed cannot do maths or string manipulations in replacement.

You may use this perl solution:

perl -pe "s~(comment_count')h+VALUESh+(h+)(d+)~$1.($2+1000)~e" file

'... comment_count') VALUES ( 16132, ...
'... comment_count') VALUES ( 16133, ...
'... comment_count') VALUES ( 17134, ...