In LibreOffice Calc how can I use Regular Expressions to find and replace every character after a pattern, and remove the pattern itself.
Example:
- 123_2015970_etgn.jpg
- 124_2015971_etgn.png
- 125_2015972_etgn.JPG
Expected result after Find & Replace (remove _etgn and everything after that pattern)
- 123_2015970
- 124_2015971
- 125_2015972
Best Answer
Try replace
_etgn.*
with nothing using regular expressions.Edit Now tested as working - note full stop is required.