[SOLVED] Retrieve last three digits in an account number
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 731This message has been edited. Last edited by: LarissaB,
Version: 8.2.03M, OS/Platform: Windows 7 & 10, Output: Excel, pdf, html