Newbie Questions

Re: Use different character to end double eval concat

erundz — Thu, 22 Mar 2012 20:33:34 GMT

Thanks, btw, this works great!

Re: Use different character to end double eval concat

Jimmy — Tue, 13 Mar 2012 19:35:14 GMT

You can set up your double eval so that it doesn't append the separator sequence at the end. It goes like this:

substring(xdMath:Eval(xdMath:Eval(d:tItems, 'concat(", ", @itemName)'), ".."), 3)

Once you have that, you can just use Anson's suggestion to wrap all of that in a concat to tack the period on at the end.

Re: Use different character to end double eval concat

Anson Hidajat — Tue, 13 Mar 2012 16:38:15 GMT

Can you just concat the whole thing with a period at the end like: concat(formula, ".")? You'll probably need to strip the last character if you don't want the comma either.

Use different character to end double eval concat

erundz — Mon, 12 Mar 2012 19:22:29 GMT

I am using xdMath:Eval(xdMath:Eval(d:tItems, 'concat(@itemName, ", ")'), "..") to display a list of a items in one line. Each item is separated by a comma, but I'd like the last item to have a period after it instead. Can I accomplish this by expanding my formula somehow (another eval/concat function?) or would I have to do some coding?