General

Re: Remove Duplicate Values from a Rich Text Field

Hilary Stoupa — Tue, 05 Jan 2016 15:39:47 GMT

Here's a 2007 version. I think you'll want something like (but with namespace prefixes, you'll have to enter the preceding-sibling portion by hand in the formula editor): eval(eval(SharePointListItem_RW[infopathDAO = string(true()) and not(DAOEmail = preceding-sibling::SharePointListItem_RW/DAOEmail)], 'concat(d:DAOEmail, " ")'),"..")

Re: Remove Duplicate Values from a Rich Text Field

JackSki — Tue, 05 Jan 2016 11:48:17 GMT

Just for reference, this is my current formula that returns all emails:

eval(eval(SharePointListItem_RW[infopathDAO = string(true())], 'concat(d:DAOEmail, " ")'),"..")

Re: Remove Duplicate Values from a Rich Text Field

JackSki — Tue, 05 Jan 2016 11:20:05 GMT

Hello Hilary,

thanks for the reply.

On the machine I'm currently on, I have InfoPath 2007 and am not able to open the file you attached. I do have InfoPath 2010 at home and can look at it there.

Re: Remove Duplicate Values from a Rich Text Field

Hilary Stoupa — Mon, 04 Jan 2016 16:05:17 GMT

Hmmm - maybe you could modify the formula you are using to populate "Combined Emails" instead? See attached for a simple sample. Save the file locally, right click & select Design to open, from there you can preview.

Remove Duplicate Values from a Rich Text Field

JackSki — Mon, 04 Jan 2016 14:27:10 GMT

Is there any way to remove duplicate values from a rich text field? I have a formula that concats a bunch of emails from a column and unfortunately some of the emails are the same as you move down the column. This ends up giving me something like this:

Combined Emails:( jack@gmail.com; sarah@gmail.com; jack@gmail.com; sarah@gmail.com)

I'm trying to get it so the above would appear as follows: jack@gmail.com; sarah@gmail.com

I figured there would be an easy formula to eliminate duplicates but so far I haven't found anything.