InfoPath Dev

The data below is being pasted into a text box. Then when the user switches to the next view (via button) a text box will be in it's place but will reformat the data...   INPUT FIELD NAME: Groups-Users    NAMG_DEDocs_Authors     NAMG_DEDocs_Invoice_Authors     NAMG_DEDocs_Invoice_UserAdmin     **DESIRED OUTPUT** FIELD NAME: Formatted-Groups-Users NAMG_DEDocs_Authors;     NAMG_DEDocs_Invoice_Authors;     NAMG_DEDocs_Invoice_UserAdmin;    If someone can help me do this that would be great! Thanks! -Kyle

Perhaps the replace() function will work in your case?  Just replace all instances of spaces (" ") with semicolons (";").  Hopefully that will work for you.

I tried that and it adds like 5 semicolons. :( If there is a way to add then and then remove all but 1, I would be fine with that too.

SOLUTION: In case anyone else has this question I figured it out! translate(normalize-space(Groups-Users), " ", ";") Remove the spaces which for some reason does not remove all spaces then translate that one space in a semicolon! :)