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

Dynamic Processing

Accepted answers

nick_ceneviva

You can use the following formula in the formula tool:

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

All comments

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

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!

texttocolumns_example.yxmd

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")

Quick Links

This months top contributors

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177

DanM 167