Good day all I am trying to return a value like this: ‘V041%’
I can get a return like this : V041% from this:
How can I add the quote so it will return ‘V041%’ ?
Thanks
"'V0" + {this.custom.twnum} + "%'"
1 Like
“Slaps forehead!”
Yep, lol.
I would use a format transform to do this; it’s a little convoluted to set up but:
''V000'%''' is the actual pattern - two '' to escape the initial single quote, the pattern is three 0s to always pad to the appropriate length, then ' around the % to make it literal, then a trailing double-single-quote (
) to add the last literal.
5 Likes