Mask the numbers in middle and show only first three and last four | Community
Skip to main content
R
rvnth
Level 5
November 12, 2023
Solved

Mask the numbers in middle and show only first three and last four

  • November 12, 2023
  • 1 reply
  • 824 views

Hi Everyone, 

 

Is there a way to personalize the email by adding a VIP number which is a column in schema with masked something like below:

in schema , column value is actually like this 12345678432

1234******432

 

Thank you in advance!

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

Hello @rvnth 

 

You can do something like this in enrichment.

 

Left(ToString(@VIPNumber), 4 )+"*****"+Right(ToString(@VIPNumber), 4 )

 

 

1 reply

_Manoj_Kumar_
Community Advisor
_Manoj_Kumar_Community AdvisorAccepted solution
Community Advisor
November 13, 2023

Hello @rvnth 

 

You can do something like this in enrichment.

 

Left(ToString(@VIPNumber), 4 )+"*****"+Right(ToString(@VIPNumber), 4 )

 

 

     Manoj     Find me on LinkedIn
    R
    rvnthAuthor
    Level 5
    November 22, 2023

    Hi @_manoj_kumar_ 

     

    can I add this values inside my delivery template? I have added but then it keep saying undefined. My target mapping was recipient table inside the delivery and this column was present in a different schema. Please suggest

     

    Best,

    Revanth

    _Manoj_Kumar_
    Community Advisor
    _Manoj_Kumar_Community Advisor
    Community Advisor
    November 22, 2023

    Hello @rvnth 

    Use this code in Enrichment and replace the @VIPNumber with your column.

         Manoj     Find me on LinkedIn
    Terms & ConditionsAccessibility statement

    Loading footer...