Skip to content

    • Beast Mode

    Beast Mode

    search and replace

    Contributor
    in Beast Mode

    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

    • 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!**

    • 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!

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Quick Links

    Categories