search and replace

damen
damen Contributor

Is there an equivalent to search and replace in ETL?

i have a data set that I need to change the word 'Not' to something else - the problem is i only want to change that word and only that word.

Any suggestions?

If this helps, feel free to agree, accept or awesome it!

Tagged:

Answers

  • RobSomers
    RobSomers Coach
    edited February 2023

    @damen What does the data look like? If the field contains things like 'Not Repeat' with not at the beginning, then you could use a formula tile and do:

    REPLACE('Not ',`Col A`,'Replacement ') --Note the space after Not

    This would work if Not is the first word for the data in the column, but it depends on what your data looks like.

    **Was this post helpful? Click Agree or Like below**

    **Did this solve your problem? Accept it as a solution!**

  • damen
    damen Contributor

    @RobSomers

    Yeah, so I have NOT in the middle of the column as well. I think I decided to break up some of the columns, replace, the concat back.

    If this helps, feel free to agree, accept or awesome it!