InfoPath Dev

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

 

How about this:

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

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

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

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

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