Data prep calculated fields

[arun_97]

The plus sign (+ (ASCII code 43)) and all subsequent characters. For example, normalize janedoe+home@gmail.com to janedoe@gmail.com.

I tried this code

replacestr(email,left(email,instr(email,"@gmail.com")),lower(trim(concat(split(left(email,instr(email,"@gmail.com")),".+")))))
but I'm not getting proper output for this code.



Referred Document:
https://experienceleague.adobe.com/docs/experience-platform/destinations/catalog/advertising/tradede...

[arijitg]

@arun_97 please check if this works for you -->

split(email,'+')[0]+'@'+split(email,'@')[1]