In your example (above) the USDAAA is always the same length and in the same position.... so you could use a substring() function in a formula as:
If the field is "flexible" (length = 6), you could use a formula like:
Substring([String Field], Findstring([String Field], "USD"),6)
or you could play with a Regular Expression as:
Regex_Replace([String Field], ".*\s(USD\w+)\s.*",'$1')
The RegEx is most flexible, but hardest to explain to your boss. it finds a group of letters/numbers preceded by USD until the following space.
P.S. I didn't test these formulas. They might need a little TLC.
Alteryx ACE & Top Community Contributor
Chaos reigns within. Repent, reflect and restart. Order shall return.
to my youTube channel.