InfoPath Dev

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! :)

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.

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: ...

An easier way to read my post .... http://s13.postimage.org/kv2e7t1zb/Question.png Here is the basic idea (small scale) of what I am dealing with... An example of the problem i'm trying to solve. google.com and youtube.com go down. The data i am given is "google.com, youtube.com" and I must retrieve the primary and secondary ...