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
Solved! Go to Solution.
Try this formula:
If Contains([Field_1],'CENTRO DE CUSTO -') Then REGEX_Replace([Field_1], ".*CENTRO DE CUSTO - (.{0,4}).*", "$1") Else "" EndIf
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.