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

Unanswered

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)

Verified answer

TheRobRush 11,128 Moderator on at

Like (1)

Report
Try using Left/Right function
Left(TextInput6.Text,8)

Was this reply helpful? Yes No
Verified answer

rubin_boer 4,841 Super User 2024 Season 1 on at

Like (1)

Report

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 (0)

Report

It worked thank you for both your direction with solution.

Was this reply helpful? Yes No

Join the conversation