InfoPath Dev

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). ?

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

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