Alteryx Designer Desktop Discussions

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

Splitting text & number

ImanJanahmadi
5 - Atom

I need help to spilt text and numbers! 
what I have is: Jackson, Tom (A123456)
What I need is: Jackson, Tom

 

 

Thank you for help. 
Iman 

 
2 REPLIES 2
Deano478
12 - Quasar

Hey @ImanJanahmadi  stick this into a formula tool and it will do the trick

REGEX_Replace([Field1], '\s\([A-Z0-9]+\)$', '')

:

binuacs
20 - Arcturus

@ImanJanahmadi another method

image.png

 

Labels