CSVValue
- function
- new in 1.79
- This function accepts text in CSV format and converts it into either a list of property lists or a list of lists.
- Parameters: The
CSVValue
function uses the following parameters:
• delimiter: The delimiter
parameter value represents a character to be used between the fields on each line. The default value is a comma.
• asLists: Setting the asLists
parameter value to Yes
tells the CSVValue
function to create a list of lists. The default value is No
, which results in the creation of a list of property lists.
• columnNames: The columnNames
parameter represents a list of names for the columns. Specify this parameter when there is no header row. The CSVValue
function ignores this parameter if the asLists
parameter is set.
• trimValues: Set this value to Yes
to trim any spaces before and after each value. The default value is No
.
** • ignoreComments:**Set this value to Yes
to recognize and ignore comments beginning with the #
character. The default value is No
.
• allowEscapes: Set this value to Yes
to allow backslashes in values to escape the character that follows the backslash. The default value is No
.
- Syntax:
CSVValue(CSVstringToEvaluate, <parameter1Name>:<parameter1Value>, <parameter2Name>:<parameter2Value>,...<parameterNName>:<parameterNValue>)
- Related: CSVFormat