InfoPath

Re: Info-Path - how to split a string into 2 substrings

derekmac — Fri, 21 Nov 2014 09:49:39 GMT

Hi Bre, Thanks for your quick reply and help that worked perfectly, you have saved me a lot of time much apprenticed Derek

Re: Info-Path - how to split a string into 2 substrings

Bre Huston — Fri, 21 Nov 2014 00:16:46 GMT

Hello derekmac,

Yes, you can use the substring functions to split the first and last name from your dropdown entries. I've attached an example for reference, but you'll want to run an action when a user selects an entry from the dropdown. The 2 formulas used are:

substring-before(FullName, " ") and

substring-after(FullName, " ")

Hope this helps!
Bre

Bre Huston | Project Manager

Qdabra® Software / InfoPathDev.com / FormsQuo / 877.544.2389 main / 425.318.7843 direct

Business Process Automation for Everyone – Streamline data gathering to turn process into knowledge.™

Info-Path - how to split a string into 2 substrings

derekmac — Thu, 20 Nov 2014 20:32:15 GMT

Hi i am using microsoft infopath to create forms for sharepoint and i was wondering how to auto populate fields with sub strings. Basically i have 3 fields; full name , first name and last name. the full name field is a drop down list containing full names. i want first name and last name to be populated based on the full name selected. so if for example say someone selects the full name "joe bloggs" from the drop down list, this selection will populate the first name field with "Joe" and the last name field with "bloggs" automatically. can i use a function in infopath to split the full name string into 2 sub strings (first name and last name). ?