News and Announcements icon

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

Power Apps - Building Power Apps

Answered

Character Split from first to last - Canvas App

Like (0) Share

Report

Report

Posted on 24 May 2021 19:49:33 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:

Using Apps Using Formulas

General Questions

Connecting to Data

All responses Img

All responses (3)

Answers Img

Answers (2)

AVTS 538 on 25 May 2021 at 07:51:21

Like (0)

Report

Re: Character Split from first to last - Canvas App

It worked thank you for both your direction with solution.
Verified answer

rubin_boer 4,841 Super User 2024 Season 1 on 24 May 2021 at 20:46:40

Like (1)

Report

Re: Character Split from first to last - Canvas App

hi @AVTS

Req 1: Left("10141400000231212",8)

Req 2: Right("10141400000231212",6)

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

TheRobRush 11,121 Moderator on 24 May 2021 at 20:41:16

Like (1)

Report
Re: Character Split from first to last - Canvas App

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