Unanswered

RETURN STRING CONDITION

(0) Share

Report

Posted on by Bingqiling

321

It has the following strings: "apple > banana > carrot" and "bee>ant".
At this time, if there are more than two ">", I will return "banana > carrot"
If there is one ">", I want to return the entire string "bee>ant".
How can we solve this?

If( 
 Len(Label9.Text) - Len(Replace(Label9.Text, ">", "", 1)) >= 2,
 Mid(Label9.Text, Find(">", Label9.Text, Find(">", Label9.Text) + 1) + 1),
 Label9.Text
)

Switch(
 Len(Label9.Text) - Len(Replace(Label9.Text, ">", "", 1)) >= 2,
 Mid(Label9.Text, Find(">", Label9.Text, Find(">", Label9.Text) + 1) + 1),

 Len(Label9.Text) - Len(Replace(Label9.Text, ">", "", 1)) < 2,
 Label9.Text
)

Both codes experience errors.
The error in the first IF() code cannot convert the ">" value to a number

The error in the second switch() code is
Invalid argument found in switch statement, invalid argument format (Number). I need a boolean value

Categories:

Building Power Apps

All responses (4)

Answers (0)

Sort by

Sundeep_Malik 6,501 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey @Bingqiling

Try this:

If(
Len(Label9.Text) - Len(Replace(Label9.Text, ">", "")) >= 2,
Mid(
Label9.Text,
Find(">", Label9.Text, Find(">", Label9.Text) + 1) + 1,
Len(Label9.Text)
),
Label9.Text
)

The error could be due to attempting to convert a non-numeric value to a number or providing an invalid argument in the Switch statement.
Bingqiling 321 on at

Like
a
(0)

Report
Copy link

Link copied!

HI, @Sundeep_Malik

An error says ">" cannot be converted into a number,,,
Bingqiling 321 on at

Like
a
(0)

Report
Copy link

Link copied!

HI, @Sundeep_Malik

Is there any other way??
Bingqiling 321 on at

Like
a
(1)

Report
Copy link

Link copied!
hi @Sundeep_Malik
If( Len(Label9.Text) - Len(Replace(Label9.Text, ">", "", 1)) >= 2, Right(Label9.Text, Len(Label9) - 1 - Find(">", Label9.Text)) , Label9.Text ) Switch( Len(Label9.Text) - Len(Replace(Label9.Text, ">", "", 1)) >= 2, Right(Label9.Text, Len(Label9) - 1 - Find(">", Label9.Text)) , Len(Label9.Text) - Len(Replace(Label9.Text, ">", "", 1)) < 2, Label9.Text )

And the code in there was wrong, so I corrected it.