InfoPath Dev

 HI

 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

 It sounds like you need this:

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

 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?