web

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

News and Announcements icon

Power Platform CommunityForums Power Apps How to separate the Mi...

Power Apps

Unanswered

How to separate the Mid values from the Textinput?

(0) Share

Report

Report

Posted on by Anandhavalli

34

Hello,

Please see the below screenshot,

I can get the First Split and Last Split values

How to get the other mid values from the Text Input.

Categories:

Building Power Apps

Split.jpg

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (3)

Verified answer

NPPlatform 606 Moderator on at

Like (1)

Report
Am I correct in assuming you want to retrieve "TAB11NEU00297"? You can do this by combining your Split-fuction with the FirstN and Last functions to access an item at a specific index. To get the 4th element from your textlabel you'd use

Last(FirstN(Split(TextLabel.Text, " "), 4)).Value
See the example below:

Does this help?

Was this reply helpful? Yes No
Verified answer

v-mengmli-msft on at

Like (2)

Report
Hi @Anandhavalli ,

If you want to get the middle text between the first and last values of the text which is split by space, you can do this:

Concat(Filter(Split(Text," "),Value<>First(Split(Text," ")).Value&&Value<>Last(Split(Text," ")).Value),Value," ")

Best regards,
Rimmon Li

Was this reply helpful? Yes No
Verified answer

Anandhavalli 34 on at

Like (1)

Report

Dear @NPPlatform

Thank you, Your solution is working fine.😊👍

Screenshot_202310...

Was this reply helpful? Yes No

Join the conversation