InfoPath Dev

Hi there,

I have an infopath filler form and when I pull data from a SharePoint 2010 list into the form, the entries are coming up with double commas between the last name and first name (IE. BLOGS,,Joe)

I have found an online fix which works when copying the data from that field in to another field and that is located below. (Last Post)

http://social.msdn.microsoft.com/Forums/en-US/8b1c119e-40b5-4da1-9e06-5cc0b14a047e/why-does-text-field-in-infopath-2010-show-user-name-with-two-commas-between-first-name-and-last

 I can't seem to apply this fix to the dropdown list within my Infopath Form, does anyone have any suggestions on how to do this or how to remove the double commas in an alternative way?

Thanks in advance

I have found a fix for this issue.

For the initial drop down I have to settle with having this set using the double commas, however when this stage is submitted and moves on to the next stage i have inserted an action which uses the concat (substring-before & after function) as mentioned in the previous post to modify the entry.

However if anyone has an alternate method which would remove the double commas in the drop down menu I would love to hear from you.

 Thanks again