web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Extract few digits fro...

Power Apps

Answered

Extract few digits from a longer number

(0) Share

Report

Report

Posted on by KLaurent

23

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

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

Adrian_Celis 1,652 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
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)
KLaurent 23 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @Adrian_Celis

Thank you very much !

Join the conversation