Hi there,
I am trying to extract the last three digits from our account numbers and then concatenate those last three with other identifying fields in order to make one identifying field.

I can do everything except for extract the last (right) three digits of the account number.

Here is my issue. The field has an A16V format since our credit cards have 16 digits in them, but we also have other accounts with 8 or 9 or even 10 digits in them, based on their product type.

I have tried the EDIT, TRIM and SUBSTR functions without any luck to get the last three from all different account types.

Has anyone else tried this? Any suggestions?

Thanks,
Larissa


Sample:
Account #: Output:
5000789482 482
1042648927156478 478
1000371628731 731

This message has been edited. Last edited by: LarissaB,

You could try using RJUST and SUBSTR

{untested}
FIELD/A3 = SUBSTR(16, RJUST(16, ACCT, 'A16'),14,16,3,'A3') ;

I owe you Waz, this worked beautifully!
Next time I wont waste two hours trying to figure it out on my own and I'm coming directly to you.

Thanks again!
-Larissa

Alternatively check out This link

T

Like the idea of a DEFINE FUNCTION for reusability.