I have the following information in one column, I just need to extract the job name from the text. The Job name starts with "XX" but that can come anywhere in the string and no definite pattern is followed. so Need to find a string starting with XX and get the whole word into another column. How can I do it ?


ABCFGTTJJ job XXVA12MX VT12MX05 VT12MX -
Type 3 job XXVA73RA step VK73RXS5 AAAAMFB08 JCL PROBLEM
Type 2 job XXVA69RA step VK69AABB ABEND=S000 U4038 OPEN or CLOSE of file PORTFIL2



The Result should be like this

XXVA12MX
XXVA73RA
XXVA69RA

Any help on this one ?