Free Trial

Alteryx Designer Desktop Discussions

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

Parse out different size numbers in various spots in a string

BonusCup
11 - Bolide

Hi,

I've been trying to search through the community but can't seem to get what I need.  In the below table, under "Machine", I am trying to just pull out the model #s but they are not in consistent locations in the string.  Can someone help in pulling these out?

 

Machine[new] Model # Onlyneed
07E4h Probably Evo 510 510
HP Compaq dc7100 SFF(PS026US) 7100
HP rp5800 5800
HP RP5 Retail System Model 5810 5810
HP Compaq dc7800 Small Form Factor 7800
HP Compaq dc7100 SFF(PS026US) 7100
HP RP5 Retail System Model 5810 5810

 

Thanks in advance!

2 REPLIES 2
Verakso
11 - Bolide

RegEx can be you friend here

 

There is plenty of tutorials on this here in the Community.

 

I am no RegEx master myself but this pattern: 

 

 

(\d{3,4})

 

  

Did the trick on you sample data

2019-06-13 22_32_12-Alteryx Designer x64 - RegEx Example.yxmd_.png

 

/Verakso

BonusCup
11 - Bolide

@Verakso , thank you.  This was exactly what I was looking for.

Labels
Top Solution Authors