https://www.infopathdev.com:443/forums/43.aspx enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/117075.aspxThu, 24 Aug 2017 14:59:14 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:117075Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/117075.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=43&PostID=117075Awesome, glad you have it working. :)https://www.infopathdev.com:443/forums/thread/117070.aspxThu, 24 Aug 2017 03:26:04 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:117070ctoper110https://www.infopathdev.com:443/forums/thread/117070.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=43&PostID=117070Success!! Please disregard my last message I got it to work. As always thank you Hilary and to this fantastic site you guys are lifesavers.https://www.infopathdev.com:443/forums/thread/117069.aspxThu, 24 Aug 2017 01:48:41 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:117069ctoper110https://www.infopathdev.com:443/forums/thread/117069.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=43&PostID=117069Thank you so much for the response Hilary. So I've cleaned up the AD and now I have First.Last but having trouble with the translate function. Does this look correct translate(., ".", " ") Also FYI I'm using the translate function to make it all caps that works and it looks like this translate(., "abcdefghijklmnopqrstuvwyxz", "ABCDEFGHIJKLMNOPQRSTUVWYXZ") any thoughts? Again thank you so muchhttps://www.infopathdev.com:443/forums/thread/117066.aspxWed, 23 Aug 2017 23:58:24 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:117066Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/117066.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=43&PostID=117066You could use the translate function to replace the period with a space (if you have a space between FIRST LAST above). You can use substring-after to get rid of AD\ - substring-after(field, "AD\")https://www.infopathdev.com:443/forums/thread/117065.aspxWed, 23 Aug 2017 21:35:07 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:117065ctoper110https://www.infopathdev.com:443/forums/thread/117065.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=43&PostID=117065Hi I'm trying to create a rule by comparing one field to another. I have a drop down that's pulling from a SharePoint list. From there I'm taking that name and putting it in a text box. Conversely I have another text field that is using the userName function to pull the logged in user's name into it. I also had to use the substring-after(userName(), "i:0#.w|") function to get rid of all of that junk before the username. I should also say at Form Load I'm using the Translate function to also make both fields capital letters to make them match as not all of the names in our AD have proper caps. So now I have in the second field exactly AD\FIRST.LAST which is fine but in the first field I just have FIRST LAST which isn't exactly the same. My question is in that text box that's pulling from the dropdown how can I add AD\before the name and a period between the First and Last name? Or have some way to trim AD\ and the period from the second field? That might be easier. Many thanks in advance