cancel
Showing results for
Did you mean: Frequent Visitor

## Extract few digits from a longer number

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 ! 🙂

1 ACCEPTED SOLUTION

Accepted Solutions  Super User

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)``

2 REPLIES 2  Super User

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)`` Frequent Visitor

Thank you very much ! Announcements #### Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community. #### Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers. Top Solution Authors
Top Kudoed Authors
Users online (6,479)