Combining 2 fields into 1

[dsanders218]

I apologize for the lack of "correct" terminology in this post, I have just recently picked up using livecycle.

Lets say I have a form with the contact info, including social security #. I want to take the first the Letters of the Last name field and the last four digits of the SS# field and combine them into a seperate field to distrubute throughout the form as a ID for that particular Patient.

Example:

inputed fields

Last Name: Doe

First Name John

Social:123-45-6789

what I want it to look like once distributed:

Patient ID:DOE6789

Hope this is enough information. I know it has to be possible, I'm just too green to even know the right keywords for a search on this. Thank you for your time.

[rajesh9g · Accepted solution]

Hello Sanders,

                     The string manipulations is possible from one object to other, in your case use the function "substring()" to extract the part of the string. I have implemented your requested query and you and download it from the link below

http://www.megaupload.com/?d=96PJ3PK4

Please let me know, in case you need more assistance and i hope this sample helps you.

thanks,

Rajesh

[dsanders218]

Absolutely Perfect. It just needed the first 3 letters of the last name, but I see exactly how to modify it for what I need. Thank you.