ArrayToCSV (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Queue, stack, list and array management functions

See also

ArrayToCSV (Function)

In french: TableauVersCSV

Converts a one-dimensional array or a two-dimensional array into a character string in CSV format.

Remark: This function can only be used on WLanguage arrays.

Versions 15 and later

This function is now available for Java applications.

This function is now available for Android applications.

New in version 15

This function is now available for Java applications.

This function is now available for Android applications.

This function is now available for Java applications.

This function is now available for Android applications.

Versions 17 and later

This function is now available for iPhone/iPad applications.

New in version 17

This function is now available for iPhone/iPad applications.

Versions 18 and later

This function is now available in Android widget mode.

New in version 18

This function is now available in Android widget mode.

Versions 21 and later

This function is now available in Apple Watch mode.

This function is now available in browser code.

This function is now available in Universal Windows 10 App mode.

New in version 21

This function is now available in Apple Watch mode.

This function is now available in browser code.

This function is now available in Universal Windows 10 App mode.

This function is now available in Apple Watch mode.

This function is now available in browser code.

This function is now available in Universal Windows 10 App mode.

Example

// One-dimensional array
sMyValues is string
// Initial array
MyArray is array of 3 strings
MyArray[1] = "A"
MyArray[2] = "B"
MyArray[3] = "C"
sMyValues = ArrayToCSV(MyArray)
// sMyValues contains: "A" + CR + "B" + CR + "C"

// Two-dimensional array
sMyValues is string
// Initial array
MyArray is array of 2 by 3 strings
MyArray[1,1] = "A"; MyArray[1,2] = "B"
MyArray[1,3] = "C"; MyArray[2,1] = "D"
MyArray[2,2] = "E"; MyArray[2,3] = "F"

sMyValues = ArrayToCSV(MyArray)
// sMyValues contains: "A;B;C"+CR+"D;E;F"

Syntax

<Result> = ArrayToCSV(<WLanguage array> [, <Column separator>])

<Result>: Character string

Character string containing the different values found in the array.
For a one-dimensional array, the array elements are converted into character string and added into the string while being separated by CR characters (Carriage Return).
For a two-dimensional array, the array elements are converted into character string and added into the string. The rows are separated by CR characters (Carriage Return) and the columns are separated by <Column separator>.

<WLanguage array>: Array variable

Name of one-dimensional or two-dimensional array that will be converted into character string. This array must be created.

<Column separator>: Optional character string

Separator used to separate the values of different columns. The column separator used by default is ";".

Remarks

The separator used in the <Result> to separates the values found on different lines is CR (Carriage Return).
The structure arrays supported are the one-dimensional arrays only.
The arrays containing UNICODE strings or variants are not supported.
For the Duration type, the value is converted into thousands of a second.

Component: wd270vm.dll