Asc
DataWindow expression function
Description
Converts the first character of a string to its Unicode code point.
A Unicode code point is the numerical integer value given to a Unicode
character.
Syntax
|
1 |
Asc ( string ) |
|
Argument |
Description |
|---|---|
|
string |
The string for which you want the code point value of |
Return value
Unsigned integer. Returns the code point value of the first
character in string.
Usage
Use Asc to test the case of a character or manipulate text and
letters.
To find out the case of a character, you can check whether its code
point value is within the appropriate range.
Examples
This expression for a computed field returns the string in code_id
if the code point value of the first character in code_id is A
(65):
|
1 |
If (Asc(code_id) = 65, code_id, "Not a valid code") |
This expression for a computed field checks the case of the first
character of lname and if it is lowercase, makes it uppercase:
|
1 |
IF (Asc(lname) > 64 AND Asc(lname) < 91, lname, WordCap(lname)) |
See also
Asc in the section called “Asc” in PowerScript Reference