Announcements
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.
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?
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
Dear @NPPlatform
Thank you, Your solution is working fine.😊👍
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 493 Most Valuable Professional
11manish 479
Haque 328
