Announcements
Attention for Customers without Multi-Factor Authentication or Single Sign-On - OTP Verification rolls out April 2025. Read all about it here.
AMN3161
256 Views, 2 Replies

Pull the last 3 numbers of a longer numebr

I figure this is simple but not sure

 

Anyone have a code to take a number like this 524641-524 and to only pull the last 3 digits of it for use elsewhere?

JelteDeJong
in reply to: AMN3161

try something like this:

Dim number = "524641-524"

Dim numberParts = number.Split("-")

Dim firstPart = numberParts(0)
Dim secondPart = numberParts(1)

MsgBox(secondPart)

Jelte de Jong
Did you find this post helpful? Feel free to Like this post.
Did your question get successfully answered? Then click on the ACCEPT SOLUTION button.

EESignature


Blog: hjalte.nl - github.com

AMN3161
in reply to: JelteDeJong

Thats a really handy command, thank you!