Insert (Lists of variables)

SplitCSV

The SplitCSV attribute function is dividing a data string and provides the divided portions in the list variable. The function ist he complementary function to the JoinCSV attribute function.

Syntax
SplitCSV(Data, [DataDelimiter], [FieldDelimiter], [DecimalCharacter], [LineFeedCharacter])
Return value
None
Parameter
Use	Name	Type	Passing	Description
Required	Data	String	ByVal	The data string to be splitted
Optional	DataDelimiter	String	ByVal	Default value: comma. The data separating character.
Optional	FieldDelimiter	String	ByVal	Default value: double quote. The field separating character
Optional	DecimalCharacter	String	ByVal	Default value: dot. The decimal character.
Optional	LineFeedCharacter	String	ByVal	Default value: pipe. The replacement character for CRLF

Example:

Dim s As String

s := 'red,green,"blue,green"'

Colors.SplitCSV(s, ",", '"')

MsgBox(Colors.Join("-"))

#shows red-green-blue,green