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

[jdunkerley79 · Accepted solution]

Try this formula:

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

[luizbezerra]

jdunkerley79 ,

Thanks for the help, I'm adapting with Alteryx.
Taking advantage of the content, I need to do a control and insert record in the table, but before I need to check if it exists on the target. if it exists I need to delete and insert.