NRGdallas
Reputation: 395
Find & Replace to retain only middle term of three
data1/data2/data3
How can I find and replace all cells with this format to only result in:
data2
Always the MIDDLE term stays.
Upvotes: 1
Views: 186
Answers (1)
tohuwawohu
Reputation: 13618
Do a search/replace, with `Regular Expressions" selected (see More Options...) with this regex in the search box:
^.*/(\<[:alnum:]*\>)/.*$
and this as replacement:
$1
This assumes that there are only three "dataX" parts in every cell. If a cell contains data1/data2/data3/data4, its content will be replaced by data3. not data2-
Upvotes: 2
Related Questions
- How to find and replace with regex in excel
- Replace all occurrences except for the 3rd
- Google Sheets find and replace regex
- Google Sheets REGEXREPLACE to keep one of repeated strings if in the middle but remove them if at the beginning or the end
- Search and replace regular expression in Open Office calc
- OpenOffice Calc, function that supports regex-replace
- Python - LibreOffice Calc - Find & Replace with Regular Expression
- Regex replace is eating up the whole string! How do I make regex ungreedy?
- Regular Expression to select everything after and including 3rd occurrence
- Regex for search and replace in Calc