Find field in file that moves a position

luizbezerra

 I need to locate a certain value, but in several files and it changes position.
I have an initial content of the file that I can locate, but I can not use example: Substring ([Field_1], 10,4), do I have any solution for this case?
I've attached a text file with two lines where it contains the information I need to find.
Thank you

Find.yxmd

teste.txt

jdunkerley79

Try this formula:

If Contains([Field_1],'CENTRO DE CUSTO -') 
Then REGEX_Replace([Field_1], ".*CENTRO DE CUSTO - (.{0,4}).*", "$1")
Else ""  
EndIf