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
Solved! Go to Solution.
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!
yes, that is correct.
only the fourth one missing the space before red text. 5th has the space.
Thank you so much!