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
20 - Arcturus

@wonka1234 Another method of using the string functions

 

binuacs_0-1661848335837.png

 

Labels