• ANSI Character Functions
• CLNTDIR Function
• CLNTNAME Function
• CURRENCY Function
• DOCPATH Function
• IN Function
• LEFT Function
• LENGTH Function
• LOWER Function
• LTRIM Function
• MID Function
• MKSTR Function
• PRGDIR Function
• RIGHT Function
• SCANSTR Function
• SPACE Function
• STR Function
• SUBSTR Function
• Text Functions
• TITLE Function
• TOKEN Function
• TOKENSUB Function
• TRIM Function
• TRIMRTF Function
• UPPER Function
• XRND Function
• XWKS Function

ANSI Character Functions

Two ANSI character functions called ASC() and CHR() are available in the Calculation dialog in CaseView to provide lookup functionality for ANSI characters and values.

ASC Function

Returns the ANSI value of a character. Any characters after the first character in Str are ignored. This is dependent on the system locale regional setting.

Syntax

ASC (Str)

Where Str contains the ANSI value to be returned.

Example

ASC('A')

This example returns a value of 65 which is the ANSI value for "A".

CHR Function

Returns the ANSI character represented by the ANSI value passed using "Value". This is dependent on the system locale regional setting.

Syntax

CHR (Value)

Where Value contains a value between 0-255 representing the ANSI character to be returned.

Example

CHR(65)

This example returns the ANSI character "A" which is the ANSI character referenced by the value "65".

Related Topics

• Text Functions