Functions Reference

Chapter 12
|
Text functions 165
Description
Returns the requested value given by valueNumber from listOfValues. Useful in
looping scripts or recursive custom calculations.
Values are text items separated by carriage returns. You can place several values
together to create a carriage return-delimited list of values. A value can be empty, a single
character, a word, a sentence, or a paragraph. When you press Enter or Return, you start
creating a new value. The last value will be recognized with or without a carriage return.
When the listOfValues parameter is a literal string, you must insert a literal carriage
return character (¶) between each item in the string. To insert a literal carriage return
character, click the ¶ button in the Specify Calculation dialog box.
Example
GetValue(“London¶Paris¶Hong Kong”;2) returns
Paris
Hiragana
Format
Hiragana(text)
Parameter
text - any text expression or text field
Data type returned
text
Description
Converts Katakana (hankaku and zenkaku) in text to Hiragana.
Example
Hiragana(“ ”) returns
KanaHankaku
Format
KanaHankaku(text)
Parameter
text - any text expression
or text field