Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I need a help on the below requirement please.
Would like to check if the 1st character of a field is text with a If statement . I am not sure how to or which function to use.
My field is a alphanumeric one. If the 1st character is string, then I have to update field with a diff value. Else it will be the field value itself.
Can anyone please help?
Many Thanks in advance
Regards
Ankhi
In an alphanumeric field, the first character will always be a string unless the field has a length of 0...
You can use IsNum() and IsText() on Left(YourField,1) to check if it's numeric (or not numeric), I believe.
@Ankhi you can try something like below
= if( istext(left(Field,1)),'Flag 1','Flag 2')
In an alphanumeric field, the first character will always be a string unless the field has a length of 0...
You can use IsNum() and IsText() on Left(YourField,1) to check if it's numeric (or not numeric), I believe.
@Ankhi you can try something like below
= if( istext(left(Field,1)),'Flag 1','Flag 2')
Thanks Kush. It worked
Thanks Or The left and IsText combination worked.