Newbie Questions

Re: help with double eval and duplicates

SusanP — Thu, 16 Oct 2014 15:10:03 GMT

Just what I needed. Thank you SOOO much! Ya'll are amazing!

Jimmy — Wed, 15 Oct 2014 14:03:17 GMT

Yes, you can simply put the predicate with the groupName path rather than the eval path:

eval(eval(path/to/my:groupName[not(my:fieldName = preceding-sibling::my:groupName/my:fieldName)], 'concat(my:fieldName, "; ")'), "..")

SusanP — Tue, 14 Oct 2014 22:06:29 GMT

Thanks to Jimmy’s post in http://www.infopathdev.com/forums/p/17807/97253.aspx#97253, I’m able to remove adjacent duplicates from a string created from repeating table with this formula:

eval(eval(groupName, 'concat(my:fieldName[not(. = preceding::*)], "; ")'), "..")

A sample result looks like this: Jones, Jerry; ; ; Landry, Tom; ; ; ; ; Johnson, Jimmy; ;

Is it possible to get rid of the duplicate semicolons?

Thanks SOOO much.