web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Character Split from f...

Power Apps

Answered

Character Split from first to last - Canvas App

(0) Share

Report

Report

Posted on by AVTS

538

Team,

I would like to split two types of string from following number.

10141400000231212

Requirement 1 :

First 8 digit.

Requirement 2 :

Last 6 Digit

Current formula.

For first req :

(Last(FirstN(Split(TextInput6.Text, "000"),1)).Result)

For Second req :

With({_dt: Last(FirstN(Split(TextInput6.Text, "000"),2)).Result },
Date(2000 + Value(Right(_dt, 2)), Value(Mid(_dt, 3, 2)), Value(Left(_dt, 2)))
)

Issue i am facing with above code is if suppose 000 is coming in first 8 digit then only first 6 characters are coming.

Example : 101414

Expected : 10141400

same issue happening in last 8 digit also.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (2)

Sort by

Verified answer

TheRobRush 11,128 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Try using Left/Right function
Left(TextInput6.Text,8)

Was this reply helpful? Yes No
Verified answer

rubin_boer 4,843 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

hi @AVTS

Req 1: Left("10141400000231212",8)

Req 2: Right("10141400000231212",6)

replace the string with the control, e.g. Right(TextInput6.Text,6)

Was this reply helpful? Yes No
AVTS 538 on at

Like
a
(0)

Report
Copy link

Link copied!

It worked thank you for both your direction with solution.

Was this reply helpful? Yes No

Join the conversation