Regex in Alteryx

[noopurjain]

Hello,

I am struggling to exact red highlighted text from below records. Can anyone please help me with this?

HP102 OC12 TACMGAFAKAO TACMWS68HAA

105 T3 TACMDAFAK31 TACMLA68HAA

1011 OC03 OLYMWAFQH07 OLYMNA02KAG

HP104OC03AUSRCOXWH01 DNTRCOSL

152 T1ZF BLDRCOKCJAA DNVRLOMA

[Taylor_S]

Hello! 

I am working to help provide a potential solution to your query but had one question. In 4 of 5 of your examples, the pattern seems to be a series of characters, followed by a space, another series of characters, space (all black), then another string of characters divided by space (red text). However, in the second to last example, this is not the case with the black and red sections being joined without spacing. Can you confirm that this is correct? 

Thanks! 

[noopurjain]

yes, that is correct.

[noopurjain]

only the fourth one missing the space before red text. 5th has the space.

[Felipe_Ribeir0 · Accepted solution]

Hi @noopurjain 

You can use regex to extract this:

[noopurjain]

Thank you so much!