We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Parsing string to take everything before space

wonka1234
10 - Fireball

Hi ,

I need help parsing a string to take everything before the first space.

 

How can i do this?

 

Sample string:

NTD.P.R.D.BTRMADF.DRP.- TEST

 

I want to take everthing before the "-", as there is a space after it.

3 REPLIES 3
DanielG
12 - Quasar

Here you go.  @wonka1234 

 

(\S+)\S{1} \S*

Qiu
21 - Polaris
21 - Polaris

@wonka1234 
Like this?

0830-wonka1234.JPG

binuacs
21 - Polaris

@wonka1234 Another method of using the string functions

 

binuacs_0-1661848335837.png

 

Labels
Top Solution Authors