Add 04 spaces when matching records on Update activity? | Adobe Higher Education
Skip to main content
Level 6
October 16, 2023
Répondu

Add 04 spaces when matching records on Update activity?

My recipients codinternocomputacional has 04 white leading spaces for each value. 

My other source CSV's "customer_cic" , which is the key to make the match, has no leading white spaces. I cannot/should modify recipients. How can I add the 04 when doing the key matching?

 

 

 

Ce sujet a été fermé aux réponses.
Meilleure réponse par ParthaSarathy

Hi @god_prophet ,

In Update data activity > Identifier > edit expression > Advanced selection > Edit the formula using an expression > concatenate customer_cic with the prefix you need to add.. Example, 

'04'+customer_cic(from File)

 

Result,

It will append 04 to the input value.

If you want to add 4 white spaces instead of 04, same you can use below expression and replace 04 and type 4 spaces in it as below,

' '+customer_cic(from File)

 

1 commentaire

ParthaSarathy
Community Advisor
Community Advisor
October 16, 2023

Hi @god_prophet ,

In Update data activity > Identifier > edit expression > Advanced selection > Edit the formula using an expression > concatenate customer_cic with the prefix you need to add.. Example, 

'04'+customer_cic(from File)

 

Result,

It will append 04 to the input value.

If you want to add 4 white spaces instead of 04, same you can use below expression and replace 04 and type 4 spaces in it as below,

' '+customer_cic(from File)

 

~  ParthaSarathy S~  Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups