Start Free Trial

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
binu_acs
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