Re: Escaping a single quotation mark

Hilary Stoupa — Mon, 02 Feb 2009 23:17:47 GMT

Hi:

You could use a different character to separate your items, like a % or something, then use translate to replace that with ', ':

translate(eval(eval(group2, 'concat(my:field3, "%, %")'), ".."), "%", "'")

for example. Of course, getting your opening ' will take another concatenation:

concat("'", translate(xdMath:Eval(xdMath:Eval(my:group1/my:group2, 'concat(my:field3, "%, %")'), ".."), "%", "'"))

The trick would be to use a character that the entries won't have -- not too bad if the field uses a drop down list, but a bit tougher if the user can enter whatever he or she likes....

Escaping a single quotation mark

B4d_k42ma — Mon, 02 Feb 2009 19:50:03 GMT

This is my formula I'm trying to insert into a field and it won't allow me to input the single quotation marks, please help.

eval(eval(group2, 'concat(my:field3, "', '")'), "..")

Right where the comma is I have double quotes followed by a single quotation mark then a comma then another sinlge quote and then double quotes, so my end result would be to have this field contain a list somewhat like this..

'Item1', 'Item2', 'Item3', 'Item4'.....ect.

Newbie Questions

Re: Escaping a single quotation mark

Escaping a single quotation mark