Data prep calculated fields | Community
Skip to main content
A
arun_97
Level 2
November 1, 2023
Question

Data prep calculated fields

  • November 1, 2023
  • 1 reply
  • 575 views

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/tradedesk-emails.html?lang=en

 



This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

arijitg
Adobe Employee
arijitgAdobe Employee
Adobe Employee
November 2, 2023

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

 

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

Terms & ConditionsAccessibility statement

Loading footer...