InfoPath Dev

Hello,

Used the code from this wonderful forum:

http://www.infopathdev.com/forums/p/20875/72441.aspx#72441

eval(eval(CountryRepeating, 'concat(my:Cntry, " | ")'), "..")

My answer ends up:

US | Thailand | UK |

Any way to make it not do the final | (pipe) after UK?

Cheers,

PAW

Please give this a try:

substring(eval(eval(CountryRepeating, 'concat(" | ", my:Cntry)'), ".."), 4)

Notice that I've surrounded it with that substring() function and reversed the order of " | " and my:Cntry.  The 4 corresponds to the length of " | " (which is 3) plus 1.

Jimmy,

Thx so much, worked like a charm!

Only one small annoyance, I could not cut and paste and I actually had to use insert Function in InfoPath for each one,

which I find a bit strange.  Microsoft could improve the Function editor to be more friendly.

PAW

If you check the Show XPath checkbox, it will show the formula in a format that can be copied elsewhere, modified and copied back.  Leaving it unchecked shows the formula in a more readable format that's not as conducive to copy-pasting.

Thx again mate!

 PAW