Function: IsAlpha
Description
Returns 1 if character is alphabetic, otherwise returns 0 (zero).
Syntax
IsAlpha(character)
Arguments
character can be a constant, a character field, an expression that results in a string or a function that returns a string. Note: If character is longer than a single character, IsAlpha operates on only the first character.
Return value
This function returns a number: 1 if character is alphabetic, otherwise it returns 0 (zero).
Calculated field example
If the Part_no field begins with an alphabetic character, the following calculated field expression would return the field value, otherwise the expression will return a blank value. This expression might be used to return only part numbers that begin with an alphabetic character code. If(IsAlpha(Part_no)=1,Part_no,"")
Filter/Find example
Records with a Part_no field beginning with an alphabetic character can be selected or found using the expression: IsAlpha(Part_no)=1
© 2024 Altair Engineering Inc. All Rights Reserved.