Newbie Questions

Combining Concat and Substring

tjb105 — Wed, 23 Apr 2014 18:07:11 GMT

I'm trying to do something similar. I would like to get the result of First Initial of Last name combined with a seperate field of last 4. This is the fomula I am using: concat(substring(@PATIENT_LAST_NAME), 1, 1) @Last_4_of_Patient_SSN

This is the error I receive:

Expected value type: end-of-string

Actual value: ..
concat(substring(../@PATIENT_LAST_NAME), 1, 1) -->..<--/@Last_4_of_Patient_SSN

Re: First Initial Last Name

Jo-Anne Alfafara — Wed, 25 Jan 2012 06:21:40 GMT

You're welcome, glad it worked!

Re: First Initial Last Name

bfry24 — Tue, 24 Jan 2012 13:39:56 GMT

Thanks again Jo Ann, that was the solution I was looking for.

Re: First Initial Last Name

Jo-Anne Alfafara — Tue, 24 Jan 2012 07:32:57 GMT

Try this: translate(concat(substring(FirstName, 1, 1), LastName), "ABCDEFGHIJKLMONPQRSTUVWXYZ", "abcdefghijklmnopqrstuvwxyz").

Hope that works! =)

Re: First Initial Last Name

bfry24 — Tue, 24 Jan 2012 05:28:29 GMT

Jo Ann, thank you very much for the assistance as that did work.

The only question is how can I get the result all in lower case.

This is what I tried but does not work:

concat(translate(substring(firstName, 1, 1 ), “abcdefghijklmnopqrstuvwyxz” ,“ABCDEFGHIJKLMNOPQRSTUVWYXZ”)), translate(substring(lastName, “abcdefghijklmnopqrstuvwyxz” ,“ABCDEFGHIJKLMNOPQRSTUVWYXZ”, ))

Re: First Initial Last Name

Jo-Anne Alfafara — Tue, 24 Jan 2012 03:17:10 GMT

Hi and welcome to InfoPathDev forums!

You'll need to use substring to get the first letter in the FirstName and then combine the result to the value of your LastName using concat, something like: concat(substring(FirstName, 1, 1), LastName)

First Initial Last Name

bfry24 — Tue, 24 Jan 2012 00:12:40 GMT

I am very new to using InfoPath and using formulas. Is there any tutorials on formulas in InfoPath?

I want to create a formula that will take the first letter in the firstName field and merge it with the entire lastName field, all in lower case.

Can anyone help with this?