First char or first 2 chars !IsNumeric: HELP!

(0) Share

Report

Posted on by 1000ghz

Dear all,

i'm in trouble with a simple function where i need to apply an IF based on the follow conditions:

IF 1st char is numeric -> write string as is (123456789 -> 123456789)

IF 1st and 2nd chars are NOT numerics -> write string as is (ab123456 -> ab123456)

IF 1st char is NOT numeric and 2nd char is numerics -> write string without 1st char (a123456 -> 123456)

I know that i have to use IF, IsNumeric, Left, Right, Len but i missed myself...

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

CNT 10,921 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@1000ghz
Try this,
If(IsNumeric(Left(yourText,1)) || !IsNumeric(Left(yourText,2)) ,yourText, If(!IsNumeric(Left(yourText,1)), Right(yourText,Len(yourText)-1)))

Was this reply helpful? Yes No
not_a_thing 65 on at

Like (0)

Report
Copy link

Link copied!
@CNThas provided a solution that should work, but what you basically have is only 1 condition for string modification: remove first char if it's not numeric, when at the same time the 2nd char is numeric. So:
If(!IsNumeric(Left(yourText,1)) && IsNumeric(Left(yourText,2)), Right(yourText,Len(yourText)-1), yourText)
same thing, only shorter

Was this reply helpful? Yes No
1000ghz 26 on at

Like (0)

Report
Copy link

Link copied!

Hi @not_a_thing and @CNT thank you so much for help but no all conditions are satisfied with your codes.
In particular when i have 1st and 2nd not numeric char like in the examples below.
What's wrong?

✔️ IF 1st char is numeric -> write string as is (123456789 -> 123456789)

✔️  IF 1st char is NOT numeric and 2nd char is numerics -> write string without 1st char (a123456 -> 123456)

✖️  IF 1st and 2nd chars are NOT numerics -> write string as is (ab123456 -> ab123456)

Was this reply helpful? Yes No
ganeshsanap 1,554 on at

Like (0)

Report
Copy link

Link copied!
@1000ghz Try something like this:

If( IsNumeric(Left(TextInput.Text, 1)) || !IsNumeric(Left(TextInput.Text, 2)), TextInput.Text, !IsNumeric(Left(TextInput.Text, 1)), Right(TextInput.Text, Len(TextInput.Text) - 1) )

Please click Accept as solution & ‌‌👍 if my answer helped you to solve your issue. This will help others to find the correct solution easily. If the answer was useful in other ways, please consider giving it ‌‌👍

Best Regards,

Ganesh Sanap

Blog site

Was this reply helpful? Yes No
Verified answer

not_a_thing 65 on at

Like (2)

Report
Copy link

Link copied!
You are right, there's an error in the code. Substitute this code
!IsNumeric(Left(yourText,2))
With this
!IsNumeric(Mid(yourText,2,1))
Left(string, 2) take the both 2 chars from the left. Mid(string, 2, 1) will take 1 char starting from 2nd char.

Was this reply helpful? Yes No
1000ghz 26 on at

Like (0)

Report
Copy link

Link copied!

Thnx @not_a_thing,
"MID" function instead of "Left" in the second condition solved my problem! 😎

Was this reply helpful? Yes No