InfoPath 2010

Re: Combine First Name Initial and last Name

chiga — Wed, 18 Sep 2013 18:22:10 GMT

Hi Jimmy

thanks for the reply, Unfortunately, that did not display the first initial.... only " . LastName"

It is not picking up substring(FullName, 1, 1)

Edit: oddly I changed it to this and it seems to have worked

concat(substring(substring-after(Full Name, ","), 1, 2), ". ", substring-before(Full Name, ","))

I assume with 1, 1 it was pulling a blank space?

Re: Combine First Name Initial and last Name

Jimmy — Tue, 17 Sep 2013 09:20:14 GMT

It sounds like you need this:

concat(substring(substring-after(Full Name, ","), 1, 1), ". ", substring-before(Full Name, ","))

Combine First Name Initial and last Name

chiga — Tue, 17 Sep 2013 02:04:14 GMT

I am trying to get the First Name initial and Last Name from a drop down list of names in the format "last name, first name". When a user selects a name from the drop down a field should display the "First Name initial and Last Name" Rabbit, Roger should be R. Rabbit

I tried concat(substring(Full Name, 1, 1), " ", substring-after(Full Name, ",")) but this will give me "Last Name Initial, First Name" (the opposite of want I need).

Thank You