Answered

String manipulation to find letter prefix.

(0) Share

Report

Posted on by martinav

3,340

I have varying strings that start with letters or numbers. If they start with letters, I need to be able to get a len() of the letters that preceed the first number in the string. I do not want it to count any letters that follow after the first number. 30m with chatgpt did not resolve this. Any help?

Logically, this should work. However, it errors.

Len(
 Left(
 Label58.Text,
 Find(
 Match(Label58.Text, "[0-9]"),
 Label58.Text,
 1
 ) - 1
 )
)

So, these text inputs should result:

"12345" Result = 0, or NULL

"123X42" Result = 0, or NULL

"vr12345" Result = 2

"Vr234abc" Result = 2

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Verified answer

TheRobRush 11,128 Moderator on at

Like (2)

Report
I'd like to preface this with

ChatGPT is so so so so so BAD at PowerApps, there are many things at which it excels, this is NOT one of them.

That out of the way,

CountRows( Filter(ForAll( Sequence(Len(Label58.Text)) As stepThrough, {Value:Last(FirstN(Split(Label58.Text,""),stepThrough.Value)).Value, Place:stepThrough.Value}), !IsNumeric(Value) && Place< First( Sort( Filter(ForAll( Sequence(Len(Label58.Text)) As stepThrough, {Value:Last(FirstN(Split(Label58.Text,""),stepThrough.Value)).Value, Place:stepThrough.Value}), IsNumeric(Value)),Place,SortOrder.Ascending)).Place))

Was this reply helpful? Yes No
mmollet 3,187 on at

Like (0)

Report

This would have taken me like 2 min if you could use/manipulate variable in a forall... Why dont they just add a normal loops functionality into power apps already. Just b/c they want it to be low code doesnt mean it cant also allow the dev to use code.. thats the one thing power apps fails miserably on imo. looping and indexing arrays would be nice to have.

Was this reply helpful? Yes No
TheRobRush 11,128 Moderator on at

Like (1)

Report

Yah I really wish (since it is built on it) they would also allow us to use Java in the apps. Like not everyone would have to, but for those of us who COULD it would be nice

Was this reply helpful? Yes No
TheRobRush 11,128 Moderator on at

Like (1)

Report

I am gonna give them the benefit of the doubt and guess it is to limit what we can do for app security reasons, might keep their app from getting verified on app store etc

Was this reply helpful? Yes No
martinav 3,340 on at

Like (0)

Report

@TheRobRush ,

Yep, this works great. Its silly that it takes so much code for such a simple task. This is the first time I have seen the syntax you used with "Place<"... What is this?? Ive been using this system for several years now. Its the first time I have seen that.

Agree with chatgpt and PA. However, it has often served well in some logic cases. It actually does pretty well with OLE statements in Flow.

Was this reply helpful? Yes No
TheRobRush 11,128 Moderator on at

Like (0)

Report
Place is just the name of the made up column we set to the value of current pass of the forall(sequence())

Place:stepThrough.Value

Was this reply helpful? Yes No