community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
SOLVED

How to Parse out text&number codes

Highlighted
Meteor

Hello,

 

I have the data below and need to parse out what is bold. I feel that this is simple but cannot wrap my head around it.  Thanks!

 

ReturnByDea FC2545537 Not load for DM CABP655270 remitDea RW0231908|

 

There is a long list that have different codes for each row.

Alteryx Certified Partner

I was able to parse out the desired strings using the following RegEx:

 

(\<\u+\d+\>)

 

Expression breakdown:

(               )   Define the expression

 \<         \>    Word string, meaning a string of characters bound by a space character on both sides

    \u+           One or more uppercase characters

         \d+      One or more number (digit) characters

Labels