how to trim and concatenate two text fields in a form

Question

Hi folks,Newbie here... have two fields in a form:  FirstName   and   LastName.    Want to have these show up later as:  LastName, FirstName.For example:    "Rick"   "Stockstill"   would show up later as:   "Stockstill, Rick"    with a comma separating names and trailing blanks removed.This is a piece of cake in Excel, but have not figured out how to do same with Acrobat.    My first try at a script looks like this:(Recipient.rawValue=trim(LastName.rawValue)+", "+FirstName.rawValue);The   "Recipient"  field is a standard text field that I'm trying to populate using the  "Calculate"  property.  The good news is that I get no error message, but the bad news is that the  Recipient  field does not get populated.Any and all assistance greatly appreciated.Till later,Rick StockstillNorth East Independent School DistrictSan Antonio, TX210-407-0317rstock@neisd.net

try67 · Accepted Answer

OK, in that case you can use this code as the custom calculation script of the Recipient field:

event.value = trim(this.getField("LastName").valueAsString) + ", " + trim(this.getField("FirstName").valueAsString);
function trim(s) {
    return s.replace(/^\s+/,"").replace(/\s+$/,"");
}

try67 · Answer

Is this a LiveCycle Designer form or an Acrobat form?

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded