Extract just the last 3 digits

AppSheet AppSheet Q&A
1

Hi,
How to do you extract just the last 3 digits without the zero from the barcode scanned. please see below

3X_1_4_14ceca01b586b1260d310ba7c9a07fbb714e5ca5.png
3X_1_4_14ceca01b586b1260d310ba7c9a07fbb714e5ca5.png591×293 143 KB

Please advise
Thanks

2

I haven’t worked with bar codes but I’m guessing that this is read into your app as text or numbers. If that’s the case, you should be able to use expressions like RIGHT(), LEFT(), MID(), SUBSTITUTE(), TEXT(), NUMBER() in combination to get what you want:

3 Likes