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

user019889

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

G_Grey

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

Here's a screenshot of where to find it:

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

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

Hope this helps!

GrantSmith

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

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

G_Grey

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

Here's a screenshot of where to find it:

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

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

Hope this helps!

GrantSmith

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

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

user019889

This is really helpful. Thank you :)