CSVToArray (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

This content has been translated automatically. Click here to view the French version.

Help / WLanguage / WLanguage functions / Standard functions / Queue, stack, list and array functions / Array functions

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

CSVToArray (Function)

In french: CSVVersTableau

Fills a one- or two-dimensional array of the specified type with the character string in CSV format passed as parameter. The array is cleared before it is filled.

Example

// Tableau à une dimension
sMesValeurs is string = "A" + CR + "B" + CR + "C" + CR + "D" + CR + "D"
// Tableau initial
MonTableau is array of 3 strings
MonTableau[1] = "Y"
MonTableau[2] = "X"
CSVToArray(sMesValeurs, MonTableau)
// Le tableau contient : "A" , "B" , "C" , "D" , "D"

// Tableau à deux dimensions
sMesValeurs is string = "A" + TAB + "B" + CR + "C" +TAB + "D" + CR + "E" + TAB + "F"
// Tableau initial
MonTableau is array of 2 by 3 strings
MonTableau[1,1] = "Y"
MonTableau[1,2] = "Z"
CSVToArray(sMesValeurs, MonTableau)
// Le tableau contient : "A;B" , "C;D" , "E;F"

Syntax

CSVToArray(<String> , <Array> [, <Column separator>])

<String>: Character string

Contains the different array elements.
For a one-dimensional array, the string will be cut according to the CR characters (Carriage Return).
For a two-dimensional array, the string will be cut according to the CR characters (Carriage Return), then according to the separator of columns. The elements will be added row by row. There will be as many rows as the number of CR characters found. Columns will be added if the maximum number of <Column separator> exceeds the number of columns in the array.
Each column must have a corresponding value for the row.
Warning: this parameter must not contain quotation marks..

<Array>: Array variable

Name of the one- or two-dimensional array where the elements found in the string must be added. This array must be allocated in a simple type or in a structure type.

<Column separator>: Optional character string

Separator used to separate the values of different columns. By default, the column separator used corresponds to "list separator" found in the regional settings of Windows.
The separator is the semicolon ";".

Remarks

The size of the array will be modified if necessary: rows and columns can be added according to the values contained in the <Chaîne>.
The structure arrays supported are the one-dimensional arrays only.
Arrays containing Unicode strings or variants are not managed.
For the Duration type, the value must be given in thousands of a second. The value 0 is not valid. You must use "0000000000".

Business / UI classification: Neutral code

Component: wd300vm.dll