Newbie Questions

Re: Concatenating 2 repeating tables using ; if they contain data

zxkuqyb — Tue, 18 Feb 2014 14:56:15 GMT

Great Post! Thanks for the formula above. I was looking for the exact same functionality and your solution worked perfectly for my situation.

Thomas N. Barrett

Re: Concatenating 2 repeating tables using ; if they contain data

tuck411 — Tue, 11 Dec 2012 14:05:55 GMT

Hi Jimmy i got it working in the end by using the below formula. substring(eval(eval(Users[. != ""] | AdditionalUsers[. != ""], 'concat("; ", .)'), ".."), 2) If i used your formula the it would merge together the two data sources and break their independent links. Thanks for you help. Rich

Re: Concatenating 2 repeating tables using ; if they contain data

Jimmy — Fri, 07 Dec 2012 04:26:11 GMT

substring(eval(eval((Users | AdditionalUsers)[. != ""], 'concat("; ", .)'), ".."), 2)

Re: Concatenating 2 repeating tables using ; if they contain data

tuck411 — Thu, 06 Dec 2012 22:51:14 GMT

That works great thanks Jimmy, i'm 99% there, the only problem now is that if i have a blank repeating dropdown group it still puts in a ";" in the concat field, it isn't until you delete the repeating group that the preceeding ";" disappears.

I think that is clear.

Cheers,

Rich

Re: Concatenating 2 repeating tables using ; if they contain data

Jimmy — Thu, 06 Dec 2012 21:37:08 GMT

How about this:

substring(eval(eval(Users | AdditionalUsers, 'concat("; ", .)'), ".."), 2)

Concatenating 2 repeating tables using ; if they contain data

tuck411 — Thu, 06 Dec 2012 17:26:12 GMT

Hi there,

I have got 2 repeating tables which i am using Eval and Concat to calculate their value into a single line file.

However now i need to combine both of these concatenated values together into a single text field depending on if they have data in them,

So far i have.

Repeating table values 1 - substring(eval(eval(Users, 'concat("; ", .)'), ".."), 2)

Repeating table values 2 - substring(eval(eval(AdditionalUsers, 'concat("; ", .)'), ".."), 2)

My Current Calculation:

concat(substring(eval(eval(Users, 'concat("; ", .)'), ".."), 2), substring(eval(eval(AdditionalUsers, 'concat("; ", .)'), ".."), 2), ";")

This combines both of the above fields but places a ';' in the field even if 'Repeating Values 2' is blank.

How can i have it so that it only puts a ';' in to seperate the values if 'Repeating Values 2' is not blank

I am using Infopath 2003.

Thanks in advance,

Rich