InfoPath 2010

Re: Remove text from field

Carphunter — Mon, 06 Jul 2015 20:17:28 GMT

Thanks once again for the help. Looks like that does just what i need.

Re: Remove text from field

Hilary Stoupa — Thu, 02 Jul 2015 23:03:37 GMT

See the attached sample - I put the rules on a button instead of on form load, but they could be put on form load. Save the sample locally, right click and select design, then preview. Modify the value in field1 to test variations.

Remove text from field

Carphunter — Thu, 02 Jul 2015 18:49:55 GMT

On form load, I'm picking up either the username or accountname from sharepoint's user profile service.

we get different formats of the name depending on browser or how the user was entered into our profile service.

so... I want to set a rule that looks at the field we retrieve and remove extraneous domain information.

example: a clean username might be jblow123. but we may get back from the system DOMAINNAME\jblow123, or jblow123@domain.com. Or... DOMAINNAME\jblow123@domain.com.

I want to make a couple of rules that say, if the returned username contains DOMAINNAME\, remove it from the string; then, if username contains @domain.com, remove it from string.

I believe this can be done with a couple of concat rules... but I'm not good at those, so looking for help.