First char or first 2 chars !IsNumeric: HELP!

[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...

[CNT]

@1000ghz

Try this,

If(IsNumeric(Left(yourText,1)) || !IsNumeric(Left(yourText,2)) ,yourText,
   If(!IsNumeric(Left(yourText,1)), Right(yourText,Len(yourText)-1)))

[not_a_thing]

@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

[1000ghz]

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)

[ganeshsanap]

@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 

[not_a_thing · Accepted solution]

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.

[1000ghz]

Thnx @not_a_thing,

"MID" function instead of "Left" in the second condition solved my problem! 😎