Hello, I would like to know if there's an easy way to add zeros before a field in adobe campaign
For example:
If the record is equal to "4", it will show 0004
if the record is equal to "32" it will show 0032
Thank you in advance
Solved! Go to Solution.
Hello, check the function LPad -> To fill with 0s at the left of the number you can use: LPad(@field, 4, '0').
With this, you will have 4 digits, with 0s at the left.
Hello, check the function LPad -> To fill with 0s at the left of the number you can use: LPad(@field, 4, '0').
With this, you will have 4 digits, with 0s at the left.
Hello Heku, just to make it clear, if I add that expression, the value will be filled with 0 until the 4th character?
Thank you in advance
Yes, if you have 4 digits in your field, it will remain the same, if you have 1 digit it will be filled with 3 0s at the left. For more info you have here a list of all database functions and how to use them: https://experienceleague.adobe.com/en/docs/campaign-standard/using/managing-processes-and-data/filte...
Views
Likes
Replies
Views
Likes
Replies