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?
Solved! Go to Solution.
Topics help categorize Community content and increase your ability to discover relevant content.
Views
Replies
Total Likes
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)
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)
Views
Likes
Replies