how to append single quote using glidefunction.concat

[PatriciaA987250]

Hi,

I want to append single quote infront of the employee id  (i.e. '00012345) using the the glidefunction:concat. I tried to escape the value with both back and forward slash but it return invalid function, Kindly provide sample, on how to concat single quote using glidefunction:concat.

tried code:

glidefunction:concat('/'', emp_num)

[Jean-Emmanuel · Accepted solution]

Hello,
You can use the following syntax: 
glidefunction:concat("'",emp_num).

Ex: In this exemple I concat single quote and incident number:

If this clarifies your question, please mark this response as helpful!

[OlaN]

Hi,

What wrong with just adding the strings together with a simple + operator ?

Like so:

var empNumber = "0123456";
var prefix = "'";

var concatBothValues = prefix + empNumber;
gs.info('concatinated: ' + concatBothValues);

// result ->> concatinated: '0123456

[Jean-Emmanuel · Accepted solution]

Hello,
You can use the following syntax: 
glidefunction:concat("'",emp_num).

Ex: In this exemple I concat single quote and incident number:

If this clarifies your question, please mark this response as helpful!

[HIROSHI SATOH · Accepted solution]

Using double quotes:
You can also enclose the string in double quotes. In this case, you can include a single quote without escaping it.

[abirakundu23]

Hi @PatriciaA987250 ,

Please try below one & it's working fine in PDI.

Please mark helpful & correct answer if worthy for you.