Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

How to Parse out text&number codes




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

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




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