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

Alteryx designer Discussions

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

How to Parse out text&number codes

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.

Highlighted
Alteryx Certified Partner
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