Free Trial

Alteryx Designer Desktop Discussions

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

Regex Parsing

eelundgren
5 - Atom

Hi,

 

I am new to Regex function. Could you please help me to parse all the words that's start with '$'?

 

Ex-

 

11:36 Drops: $LAIX -6.4%, $SNMP -4.1%, $SOS -4.0%, $TRIT -3.8%, $SAVA -3.7%, $ALT -3.5%, $ASTC -3.5%

 

Need Output-

 

$LAIX , $SNMP , $SOS , $TRIT , $SAVA , $ALT, $ASTC 

 

Any help would be appreciated.

 

Thanks

1 REPLY 1
AngelosPachis
16 - Nebula

Hi @eelundgren ,

 

You can use a regex tool and set it to tokenize on

 

\$\u+

 

that will return every instance of a dollar sign, followed by one or more uppercase characters.

 

 

AngelosPachis_0-1612552518974.png

 

Let me know if that works for you.

 

Regards,

 

Angelos

 

Labels
Top Solution Authors