Add 04 spaces when matching records on Update activity? | Community
Skip to main content
Level 6
October 16, 2023
Solved

Add 04 spaces when matching records on Update activity?

  • October 16, 2023
  • 1 reply
  • 555 views

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?

 

 

 

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 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 reply

ParthaSarathy
Community Advisor
ParthaSarathyCommunity AdvisorAccepted solution
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