InfoPath Dev

All,

I'm using the GetUserProfile service to return various user attributes. I'm specifically using it to pull into an InfoPath 2010 form the MySite About Me. I've got this to work, yet the returned viewable text includes &nbsp i.e. System, XYZ  It doesn't seem to matter if the field is a text or a rich text box.  I've tried the following formula value: translate(Value[Name = "AboutMe"], " ", " ") . This however removes all &nbsp (s)

How can I remove the " " and be presented with a space in the resulting field?

Thanks

The translate function should work for your case.  Are you saying it removes all the &nbsps but doesn't add a space?

In this case, the translate() function would replace all of the &s with spaces and remove all of the ns bs ps ss and ;s.

    An example    -->  A examle

InfoPath doesn't provide a good way to do multicharacter string replacements, unfortunately.  Another forum user asked about this last week, and I gave him my suggestions in that thread:

http://www.infopathdev.com/forums/p/22974/79487.aspx#79487

Apologies one and all.

The translate function appears to translate on a letter by letter basis, not on a word basis. Oh well. I couldn't find a find and replace either.

My &nbsp s were appearing in the InfoPath "Preview in Browser" option only, then on a hunch I put the form into a SP WebPart page, the &nbsp s disappeared. I guess I'll have to 'publish' my forms much earlier.

Thanks

A