Applies to Infiniti v8.0 or later
 
This function allows characters to be referenced by their ASCII decimal code. This is useful for when characters, such as the copyright symbol ‘©’, are not readily available on the keyboard.

Usage

chr( v )

Parameters

v - The ASCII decimal code of the required character or symbol.

Example

Insert a copyright symbol ‘©’: The ASCII decimal code for the ‘©’ symbol is 169.
 
chr(169)
 
Used within an IIF function
 
The following iif() statement compares the answer value of another question to a fixed string.
 
iif(IsEqual([Q1.Currency],"GBP"), chr(163),"$")
 
The formula returns a ‘£’ symbol if the value is ‘GBP’ otherwise it returns a ‘$’ symbol.
 
ASCII comma in concat
concat([q1.surname],chr(44)," ",[q1.firstname])
 

 

Related Articles

 

Keywords

join concat format style text iif comma symbols symbol character first firstname surname currency equal