Free Trial

Alteryx Designer Desktop Discussions

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

Parsing numbers & digits (copy output)

tiverson
8 - Asteroid

I have data that contains a code in parenthesis that I need to copy to another column, yet keep the code in the original text

tiverson_2-1645388369637.png

 

 

3 REPLIES 3
atcodedog05
22 - Nova
22 - Nova

Hi @tiverson 

 

Here is how you can do it.

Workflow:

atcodedog05_0-1645388951545.png

 

Hope this helps : )

 

binuacs
21 - Polaris

@tiverson another method

Trim(SubString([Company & Code],FindString([Company & Code], '(') + 1,Length([Company & Code])),')')

binuacs_0-1645389644938.png

 

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @tiverson 

Cheers and have a nice day!

Labels
Top Solution Authors