MichaelTamoush
3 years agoQrew Captain
Re: Search all parts of a combined text field and delete parts that contain a certain string
For example a record might include the following:
[Fiscal Year of Travel Start] Example: 2021
[Combined Text Field] Example: 2021+Words and prices ; 2021+Different Words and Prices ; 2022+Words and prices ; 2022+Different Words and Prices
My goal:
Formula which says, if Fiscal Year of Travel Start = 2021, then only keep parts with 2021+.
After that, ill do a search and replace to get rid of the 2021+, or whatever fun stuff I want to do. Note - the plus '+' sign I only include because I find it helpful in searchandreplace or using left or right, as my 'Words and Prices' can actually include 2021 coincidentally, so I just stick an impossible character onto my 2021 just in case.....
------------------------------
Mike Tamoush
------------------------------
[Fiscal Year of Travel Start] Example: 2021
[Combined Text Field] Example: 2021+Words and prices ; 2021+Different Words and Prices ; 2022+Words and prices ; 2022+Different Words and Prices
My goal:
Formula which says, if Fiscal Year of Travel Start = 2021, then only keep parts with 2021+.
After that, ill do a search and replace to get rid of the 2021+, or whatever fun stuff I want to do. Note - the plus '+' sign I only include because I find it helpful in searchandreplace or using left or right, as my 'Words and Prices' can actually include 2021 coincidentally, so I just stick an impossible character onto my 2021 just in case.....
------------------------------
Mike Tamoush
------------------------------