Select first part of a string

[murrayjl03]

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

[AmeliaG]

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! 

[nick_ceneviva · Accepted solution]

You can use the following formula in the formula tool:

SUBSTRING([Field Name],0,FINDSTRING([Field Name],"\"))

[AmeliaG]

I've attached an example workflow here :)

Have a great day!

[Kenda]

Hey @murrayjl03! Yet another way to accomplish what you're wanting is to add the following in a Formula tool:

REGEX_Replace([Field1], "(.*?)\\.*", "$1")