community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Select first part of a string

Meteor

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

Alteryx
Alteryx

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! 

Highlighted
Alteryx Certified Partner

You can use the following formula in the formula tool:

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

I've attached an example workflow here :)

 

Have a great day!

Pulsar
Pulsar

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

 

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