Hi,
I have various strings:
TestString1.xls\Test\Documents
Test String 2.xls\Test\Documents
I want to select the first part of the string up to the "\".
Thanks
Solved! Go to Solution.
Thanks for your question!
For this I would use a 'Text to Columns' tool with the \ as the delimiter. This will break your string field into two separate fields. The first output field is your desired result.
Hope this helps!
You can use the following formula in the formula tool:
SUBSTRING([Field Name],0,FINDSTRING([Field Name],"\"))
Hey @murrayjl03! Yet another way to accomplish what you're wanting is to add the following in a Formula tool:
REGEX_Replace([Field1], "(.*?)\\.*", "$1")