Hello,
i would like to extract few digits from a longer number.
For exemple :
i have that number : 0207613031466050420001523033148721010650914PB
and i want to separate like that :
02
076130314660504
20
00
15
230331
4872
10
10650914PB
Thank you for your help ! 🙂
Solved! Go to Solution.
Hi @KLaurent
You can use Left, Mid, and Right functions to extract a portion of a string.
For example we put the sample number combination into a variable named 'varNumber'
Set(varNumber,"0207613031466050420001523033148721010650914PB")
If the length of the numbers is always going to be fixed, then you can use this formulas, respectively :
Left(varNumber,2)
Mid(varNumber,3,15)
Mid(varNumber,18,2)
Mid(varNumber,20,2)
Mid(varNumber,22,2)
Mid(varNumber,24,6)
Mid(varNumber,30,4)
Mid(varNumber,34,2)
Right(varNumber,10)
Hi @KLaurent
You can use Left, Mid, and Right functions to extract a portion of a string.
For example we put the sample number combination into a variable named 'varNumber'
Set(varNumber,"0207613031466050420001523033148721010650914PB")
If the length of the numbers is always going to be fixed, then you can use this formulas, respectively :
Left(varNumber,2)
Mid(varNumber,3,15)
Mid(varNumber,18,2)
Mid(varNumber,20,2)
Mid(varNumber,22,2)
Mid(varNumber,24,6)
Mid(varNumber,30,4)
Mid(varNumber,34,2)
Right(varNumber,10)
User | Count |
---|---|
257 | |
110 | |
95 | |
57 | |
40 |