Split Function

[mmattar]

Hello all,

Trying to split this text:

Just some test text here - I.E. Relief - 80003333333 , how would i grab I.E. Relief - 80003333333 out of this ?

Thanks 

[eka24]

The quesTion and the what you expect are the same. What do yo want to grab? 80003333333  or "Relief" or I.E

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[mmattar]

I'm trying to grab I.E. Relief - 80003333 out of "This is some random text - I.E. Relief - 80003333"

[Krishna92]

@mmattar 

Please use the below expression to achieve the same.

Concat(LastN(Split("Just some test text here - I.E. Relief - 80003333333"," - "),2).Result,Result & " - ")

If this information helps you with resolution, please consider giving a thumbs up and mark the solution as resolved.

[eka24 · Accepted solution]

Assuming the text in TextBoxA, In the default of TextSearchBox, put:

Right(TextSearchBox.Text,Len(TextSearchBox.Text)-Find("-",TextSearchBox.Text))

Change TextSearchBox to your actual textbox name

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[mmattar]

Hey this works but it keeps adding an extra " - " to the end. This is the result:  "I.E. Relief - 80003333333 - ", how can i rid of the extra " - " at the end and just get I.E. Relief - 80003333333

[eka24]

Did you try what i gave, there is no "-" at the end:

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[Mr-Dang-MSFT]

Hi @mmattar ,

You might also be interested in using the regex functions Match() and MatchAll(). 

MatchAll() returns a table of matches that contain the criteria you set.

Match() returns the first match.

It is more flexible than Split(), but can be intimidating at first. The good news is that regex is an established concept and you can search the internet for the exact pattern you want.

Suppose the pattern in this scenario is [one word] [hyphen] [digits]. In regex, this might translate to something like:

• a single word: \w{1,}
• hyphen and spaces: ( - )
• digits: \d{1,}

To make more sense of it:

• \w returns a word and {1,} designates a word containing at least one character with no upper boundary.
• ( - ) matches exactly one space, a hyphen, and one space. Anything enclosed in parentheses is case sensitive and must be exact.
• \d returns a digit and {1,} again designates a length of at least one digit with no upper boundary

And in Power Apps, it can be implemented like this:

Match(
    "Just some test text here - I.E. Relief - 80003333333 , how would i grab I.E. Relief - 80003333333 out of this ?",
    "\w{1,}( - )\d{1,}"
).FullMatch

The regex attempts to find a set of characters that include one word, a space, a hyphen, a space, and at least one digit. Match() returns a record, so using a dot and FullMatch returns the actual string that was matched. 

Suppose you know all the individual words to expect ahead of the hyphen. You can use this regex instead:

(Relief|Option 2|Option3)( - )\d{1,}

In the example above, Match() will try to find one of those options, whether it is Relief, Option 2, or Option 3 followed by the hyphen and digits. Because it's enclosed in parentheses, it is case sensitive and matches must be exact.

Let me know if this helps you achieve a more dynamic search.