Answered

Split on "-" but not if there is "\" before the "-"

(0) Share

Report

Posted on by Jebbis

Hi,

I have a combination of different values in PowerApps that are separated with "-" character. I have came a cross a situation where there can be "-" character in the middle of value. Good thing is that there is always "\" character before it if its in the middle of the value.

Example value = 012-MT\-1234-022
Desired result of split = 012, MT-1234, 022

Note that I want to remove that "\" character from the end result too.

I cant seem to find a way to do this.

Thank You.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

v-mengmli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Jebbis ,

Here is a method for your reference.

Substitute(Substitute(Substitute("012-MT\-1234-022","\-","#"),"-",","),"#","-")

Best regards,

Rimmon

Was this reply helpful? Yes No
Jebbis 10 on at

Like (0)

Report
Copy link

Link copied!

Hi,
I think I was not clear enough of my situtation, sorry.
I want the split to be dynamic. I have many different combinations that comes from a variable.
for example:
012-MT\-2144-999,
102-MT\-555-13621,
6231-MT\-7432-12
etc.
I want to split them in to a table that I can use in combobox.
Thank you

Was this reply helpful? Yes No
Verified answer

v-mengmli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Jebbis ,

Do you mean this?

Split(Substitute(Substitute(Substitute("012-MT\-1234-022","\-","#"),"-",","),"#","-"),",")

Was this reply helpful? Yes No
Jebbis 10 on at

Like (0)

Report
Copy link

Link copied!

Yes! This seems to work just like I want it thank you!

Was this reply helpful? Yes No