Hi,
This is my first post on this forum, so please be kind.

I need to add either a 's or ' to the end of my variable, depending on if the variable ends in an "s" or not.

For example:
John's Snapshot
or
Lucas' Snapshot

I can do this with JavaScript with the code below, but I'm not sure how to do this with the WebFOCUS Language. Thanks in advance.

function setFirstName() {
var s = (local_ibi_client_fname.charAt(local_ibi_client_fname.length-1) == 's')? "'" : "'s";
document.getElementById('client_fname').innerHTML = local_ibi_client_fname + s + " Snapshot";
}

This message has been edited. Last edited by: <Kathryn Henning>,

Hi,

How about this:

-*
-SET &FNAME = 'John';
-*-SET &FNAME = 'Lucas';
-*
-SET &FN_LST = SUBSTR(&FNAME.LENGTH, &FNAME, &FNAME.LENGTH, &FNAME.LENGTH, 1, 'A1');
-SET &FN_NEW = IF &FN_LST EQ 's' THEN &FNAME || ''' Snapshot' ELSE &FNAME || '''s Snapshot';
-*
-TYPE FNAME ------ &FNAME
-TYPE FN_LST ----- &FN_LST
-TYPE FN_NEW ----- &FN_NEW
-EXIT
-*

Give it a try and let me know.

Perfect! Thank you!

If you're planning on using that variable in any FOCUS expression, such as a DEFINE or WHERE clause, make sure to suffix it with .QUOTEDSTRING instead of enclosing it in single quotes as that apostrophe in the data may cause some issues.

-* In a DEFINE expression
DEFINE FILE BLAH
FULL_NAME/A60 = &FN_NEW.QUOTEDSTRING;
END
...
TABLE FILE BLAH
PRINT ....
WHERE NAME EQ &FN_NEW.QUOTEDSTRING
END

I would also syggest that you truncate or right justify the variable before getting the last char, just in case there are trailing spaces.

-SET &FNAME = TRUNCATE(&FNAME) ;
or
-SET &FNAME = RJUST(&FNAME.LENGTH,&FNAME,'A&FNAME.LENGTH') ;