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

@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:

Strip dots to match emails.yxmd