JoinCSV

concerns

The JoinCSV attribute function returns the values of the list concatenated in a string, in a more complex manner than the Join attribute function.

 

Syntax

JoinCSV([DataDelimiter], [FieldDelimiter], [DecimalCharacter], [LineFeedCharacter])

Return value

Type

Description

String

Values formatted in a complex CSV

Parameter

Use

Name

Type

Passing

Description

Optional

DataDelimiter

String

ByVal

Default value is comma.

The data separating character.

Optional

FieldDelimiter

String

ByVal

Default value is double quote.

The field separating character, if necessary.

Optional

DecimalCharacter

String

ByVal

Default value is dot.

The decimal character.

Optional

LineFeedCharacter

String

ByVal

Default value is pipe.

Replacement character, if there is a CR-LF recognized in data.

 

Example:

 

Colors.Add({"red", "blue", "green;blue"})

MsgBox(Colors.JoinCSV(";", "/"))

#shows red;blue;/green;blue/