Ignoring a "dot"

[Jay2022]

Hello,

I'm trying to set up a flow where I can have either a tool or formula to ignore "dot" within an email such as from "gmail". Basicaly I need to make sure even though there is a "dot" in your name  my output would be the same from joining 2 files. Example, if the original email is "peterpan@gmail" and i use "p.eterpan@gmail" the match would be same as if I entered "peterpan".

Any ideas on how to begin will be appreciated.

[DataNath · Accepted solution]

@Jay2022 on either side of your join, use a Replace() function to remove full stops from the email addresses in both data streams. If you make this as a new field then use the two of these as the join condition, after the join you’ll still have the originals.

Replace([FieldName],'.','')

Quick example attached:

[Emmanuel_G · Accepted solution]

@Jay2022 

Find attached two ways of doing that.

Please do not hesitate to mark this answer as solution if it helped.

[Jay2022]

thank you so much for that!! this works as desired