Hi, very new to this but I have the basics.
Situation:
I have a people picker pulling from an ishare list of names. I want to take the result from this people picker, and pass it to a normal text field. (the people picker still needs to display itself in it's origional form in it's own field) However, it needs to be in a different format and be somewhat cut down in the second text field, "AppName".
current result in the text field: NETWORK\First.Last
Desired result in the text field: First Last
ex. "NETWORK\John.Smith" becomes "John Smith"
were this code, I would do somthing to the effect of ["NETWORK\" = '\0'] and ["." = " "]
or somthing to that effect (not working code, I know). I tried doing somthing like this in the formula box, it returned "false" when previewing the form however. Any help? I've seen somthing called "concat" thrown around the web, dont understand it...
Attempted Method:
picker pulls successfully, and displays as desired in it's box. I have the text field, "AppName", default value to "AccountID" as it has the least extra stuff in comparison to "DisplayName".
I have attempted using the translate function, successfully removing and replacing the "." with a space, but it doesnt work at all with actual strings, so im stuck on the removing "NETWORK\" bit with NULL space