How remove all characters after pattern in LibreOffice Calc
6,964
Solution 1
Try replace _etgn.*
with nothing using regular expressions.
Edit Now tested as working - note full stop is required.
Solution 2
i know its pretty old but here is a solution to that. whatever you want to remove before or after a symbol/char you can use the star symbol
*<yourcharcter>
,to remove everything before this character
<your_char>*
to remove everthing after it.
But before doing it you should enable wildcard option.
Related videos on Youtube
Author by
mara19
Updated on September 18, 2022Comments
-
mara19 about 1 year
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
-
chuff over 10 yearsWould the period (.) need to be escaped in order to find it as a literal? (I'm not at all familiar with LibreOffice).