How should can i remove Dot "." from a column?

user019889
user019889
in Beast Mode

Hello,

I have a column with multiple data and i need to remove the dot from all of it while keeping the letters and numbers. What should i use in ETL? Will Regex works? If yes, what should be the formula

Example of column data:

12412.oaf.124R

124.1256612.124

saarw.124.1fs

Tagged:

Best Answers

  • G_Grey
    G_Grey Contributor
    Answer ✓

    You should be able to resolve this by using replace text in Magic ETL.

    Here's a screenshot of where to find it:

    image.png

    In this example I have this highly complex table, behold my unstoppable data prowess:

    image.png

    Then by adding replace text and replacing "." with an empty string the output table returns this:

    image.png

    Hope this helps!

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    You can also use a formula tile and a regex to do this as well:

    REGEXP_REPLACE(`Field`, '.', '')


    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Answers

  • G_Grey
    G_Grey Contributor
    Answer ✓

    You should be able to resolve this by using replace text in Magic ETL.

    Here's a screenshot of where to find it:

    image.png

    In this example I have this highly complex table, behold my unstoppable data prowess:

    image.png

    Then by adding replace text and replacing "." with an empty string the output table returns this:

    image.png

    Hope this helps!

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    You can also use a formula tile and a regex to do this as well:

    REGEXP_REPLACE(`Field`, '.', '')


    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • user019889
    user019889

    This is really helpful. Thank you :)

Categories