Join the Inspire AMA with Joshua Burkhow, March 31-April 4. Ask, share, and connect with the Alteryx community!

Alteryx Designer Desktop Discussions

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

How to parse everything before a special character?

Hoss2434
7 - Meteor

I have some data that needs to be separated before a special character indicator. For example, here is what the data looks like before:

 

getInfoRed.12354

getInfoGreen?54698

getInfoBlue/98765

 

And here is the desired outcome I am trying to achieve:

 

getInfoRed

getInfoGreen

getInfoBlue

 

Any help would be greatly appreciated. Thanks!

 

3 REPLIES 3
binuacs
21 - Polaris
Spoiler
binuacs_0-1637566588513.png

 

messi007
15 - Aurora
15 - Aurora

@Hoss2434,

 

Please see below how you can do it :

 

messi007_0-1637568462469.png

 

Attached the workflow.

Hope this helps!

 

Regards,

Qiu
21 - Polaris
21 - Polaris

@Hoss2434 
By a special character, i think we can assume that it is not word character or digit.

1122-Hoss2434.PNG

Labels
Top Solution Authors