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