Announcing the launch of new sub-community for Campaign Web UI to cater specifically to the needs of Campaign Web UI users!
SOLVED
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?
Topics
Topics help categorize Community content and increase your ability to discover relevant content.
1 Accepted Solution
Correct answer by
Hi @ogonzalesdiaz ,
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)
Correct answer by
Hi @ogonzalesdiaz ,
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)
