General

Re: Combining fields with formatted text in a Repeating Section - Part 2

PAWInfo — Mon, 04 Jun 2012 00:56:50 GMT

Thx again mate!

PAW

Re: Combining fields with formatted text in a Repeating Section - Part 2

Jimmy — Thu, 31 May 2012 07:55:17 GMT

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.

Re: Combining fields with formatted text in a Repeating Section - Part 2

PAWInfo — Wed, 30 May 2012 23:54:08 GMT

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

Re: Combining fields with formatted text in a Repeating Section - Part 2

Jimmy — Tue, 29 May 2012 06:54:45 GMT

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.

Combining fields with formatted text in a Repeating Section - Part 2

PAWInfo — Tue, 29 May 2012 03:18:12 GMT

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