I have to make substitution in some files and I can not write an expression that works. I have this text at the beginning of each line:
NF3-9-16S_S9_1456 | M02255: 210: 000000000-B9K3P: 1: 1101: 14397: 18152 1: N: 0: 9 | o: 50 | m / o: 0.720000 | MR: n = 0; r1 = 34; r2 = 2 | Q30: p = 97; p = 100 | CO: 0 | mismatches: 36
And it has to look like this:
Re1_91910_1456
I should just keep the part where the number "1456" is, ie change the beginning and erase everything that comes after the number.
Response
Use this regex to capture what you want:
NF.*?(\d*)\|.*
And that part in replacement
Re1_91910_$1
Resulting in:
Re1_91910_1456
You can test the operation of this regex here.
Explanation:
This regex will capture all digits after _ and before the | character by placing them in capture group 1, after that in the part of the replacement regex, we add its fixed string Re1_91910_ and what was captured in group 1, indicated by $1 , so you get the result that you would like.