help with double eval and duplicates - InfoPath Dev
in

InfoPath Dev

help with double eval and duplicates

Last post 10-16-2014 08:10 AM by SusanP. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 10-14-2014 03:06 PM

    help with double eval and duplicates

    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. 

    Susan Pierce
    University of Texas at Arlington
  • 10-15-2014 07:03 AM In reply to

    Re: help with double eval and duplicates

    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, "; ")'), "..")

    Jimmy Rishe / Software Developer / Microsoft MVP
    Qdabra Software
  • 10-16-2014 08:10 AM In reply to

    Re: help with double eval and duplicates

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

    Susan Pierce
    University of Texas at Arlington
Page 1 of 1 (3 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.