Picking out a particular string at random positions within a field

[atharvasonavane]

I am trying to extract account references from a field that contains references starting with 'USD' and occurring at different locations.
Refer below table for better understanding

Input	Expected Output
Field testing code (USDYUIOP)	USDYUIOP
Testing code is-USDMNBVC For given account	USDMNBVC
Frame (R2D2) test code (USDFGHJK)	USDFGHJK
Sub frame code-USDQWERT	USDQWERT

[Clifford_Coon · Accepted solution]

Hi @atharvasonavane 

You can try parsing with:       \.*(USD\w{5})

[atharvasonavane]

Thank you