General

Re: ignore duplicate text when concatenating with double eval

sposit — Wed, 14 May 2014 22:28:07 GMT

Double eval doesn't seem to be the issue -- it's the addition of the [not(. = preceding::*)]. The Design Checker doesn't actually say much of anything -- it only includes a couple items: 1) Data connections contain parameterized queries and 2) Could not verify the form template on the specified server. Strangely, when I revert back to the old version of the equation, the Design Checker then populates with a whole bunch of (mostly cosmetic) issues. The checker apparently can't even review the form template (error #2) while the updated equation is in place.

Re: ignore duplicate text when concatenating with double eval

Hilary Stoupa — Tue, 13 May 2014 16:29:18 GMT

Double eval is compatible with browser forms. What does the design checker say the issue is?

Re: ignore duplicate text when concatenating with double eval

sposit — Tue, 13 May 2014 16:21:00 GMT

Correction: I can't seem to publish a web form with the formula above -- when publishing, I get an error that the form can only be published as a Filler form. Is this kind of formula not compatible with web forms? (This is in SharePoint Online, fwiw.) Thanks for any help you can provide.

Re: ignore duplicate text when concatenating with double eval

sposit — Wed, 07 May 2014 20:01:17 GMT

So I tried this: substring((eval(eval(FieldName[not(. = preceding::*)], 'concat(., "; ")'), "..")), 0, (string-length(eval(eval(FieldName, 'concat(., "; ")'), "..")) - 1))

enabled form ... is this formulation not allowed in browser forms?

Thanks,

Tyler

Re: ignore duplicate text when concatenating with double eval

sposit — Thu, 01 May 2014 17:58:31 GMT

Jimmy, can you revisit this with a bit simpler example please? I don't have the nested repeating fields, but still want to remove any duplicates. My aggregate formula looks like this:

substring((eval(eval(FieldName, 'concat(., "; ")'), "..")), 0, (string-length(eval(eval(FieldName, 'concat(., "; ")'), "..")) - 1))

(The substring is merely to remove the final semicolon.)

Thanks in advance!

Tyler

Re: ignore duplicate text when concatenating with double eval

rmsphoto — Tue, 14 Dec 2010 14:34:56 GMT

The sub-lists are formed in 9 different fields (representing work disciplines). The user selects from a "people picker", or from a fixed list for each discipline; and the same personnel may be selected for multiple disciplines. Each of the nine sub-lists is built from using rules. So I don't think the double eval would work for those sub-lists...

Again, I really appreciate your taking the time to help!

Re: ignore duplicate text when concatenating with double eval

Jimmy — Tue, 14 Dec 2010 03:48:10 GMT

Yes, I don't think it's going to be possible to come up with an expression to filter out duplicates from within the individual strings.

How are the sub-lists getting formed? Are you using a separate double-eval for each of those? If so, it's probably possible to formulate the main double-eval to concatenate all of the e-mails without first assembling them into sub-lists. That would probably succeed in excluding all the duplicates.

Re: ignore duplicate text when concatenating with double eval

rmsphoto — Mon, 13 Dec 2010 19:18:13 GMT

Very nice! This works perfectly when each field is identical, but it does not seek and destroy individual duplicate email addresses that are nested among different strings that are concat'd.

e.g.
works when field1="fred@email.com", and field2 also = "fred@email.com"
result: fred@email.com

but does not work when field1="fred@email.com; joe@email.com", and field2="rob@email.com; fred@email.com"
result:fred@email.com; joe@email.com; rob@email.com; fred@email.com (i.e. "fred@email.com" is still duplicated)

I think my request may not quite be feasible in a codeless world... Still - a very nice addition to the formula, that I will implement.

Thanks,

Re: ignore duplicate text when concatenating with double eval

Jimmy — Mon, 13 Dec 2010 18:38:48 GMT

Please give this a try

substring(eval(eval((EDG-EEEmail | EDG-MEEmail | EDG-DD1Email | EDG-PlasticsEmail | EDG-EETEmail | EDG-MTEmail | EDG-DD2Email | EDG-TWEmail)[. != ""][not(. = preceding::*)], 'concat("; ", .)'), ".."), 3, 10000)

That is, add [not(. = preceding::*)] after [. != ""]

Re: ignore duplicate text when concatenating with double eval

rmsphoto — Mon, 13 Dec 2010 18:02:16 GMT

Here is the current double eval formula:

substring(eval(eval((EDG-EEEmail | EDG-MEEmail | EDG-DD1Email | EDG-PlasticsEmail | EDG-EETEmail | EDG-MTEmail | EDG-DD2Email | EDG-TWEmail)[. != ""], 'concat("; ", .)'), ".."), 3, 10000)

Note: Each of the fields in this formula, may have multiple emails within, separated by "; ". These fields are built by straight rules. This is how the final concat'd string may contain 20+ emails, with possible repeats...

example:
1) EDG-EEEmail = fred@email.com; joe@email.com; george@email.com
2) EDG-EETmail = jim@email.com; fred@email.com
3) EDG-TWemail=rob@email.com; fred@email.com

concat'd result = fred@email.com; joe@email.com, george@email.com; jim@email.com; fred@email.com; rob@email.com; fred@email.com

would like it to be instead = fred@email.com; joe@email.com, george@email.com; jim@email.com; rob@email.com

Thanks for your help!

Re: ignore duplicate text when concatenating with double eval

Jimmy — Mon, 13 Dec 2010 15:47:26 GMT

Could you show us what your formula is right now? I think I've found a way to accomplish this.

Re: ignore duplicate text when concatenating with double eval

rmsphoto — Mon, 13 Dec 2010 15:00:06 GMT

I appreciate your taking the time to think about this, and post a reply. (Luckily, even with the same address listed multiple times, the user only receives a single email. - So it's not a biggie, anyway...) Thanks, again,

Re: ignore duplicate text when concatenating with double eval

Patrick Halstead — Mon, 13 Dec 2010 13:47:28 GMT

Hi RMSPhoto,

There's no way to filter out duplicates in the double eval. You may be able to filter them out in the form though by creating a separate hidden repeater that you set with the values of the first one. I can't think of how to do this right now, but there may be a way to limit it to unique values using rules. That's all I can think of though.

ignore duplicate text when concatenating with double eval

rmsphoto — Wed, 08 Dec 2010 19:14:51 GMT

I have applied learning from the previous post http://www.infopathdev.com/forums/t/16943.aspx to concatenate several fields - works beautifully! But here's my new catch: This function is building a list of email address from various fields - up to 20+ recipients. It is very possible that the user will select the same person for several roles, therefore adding the same email to the string multiple times. Is there a way to prevent/ignore/remove duplicated field data in the final concatenated string? Thanks for any help,