<Array>.DeleteDuplicate (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

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

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

<Array>.DeleteDuplicate (Function)

In french: <Tableau>.SupprimeDoublon

Deletes the duplicates from an array.

The following arrays can be handled:

One-dimensional array of simple elements.
Two-dimensional array of simple elements. Duplicates are deleted according to the value of one or more columns.
One-dimensional array of classes or structures. Duplicates are deleted according to the value of one or more members.
One-dimensional array by providing a comparison procedure.

Note: The <Array>.Distinct function is used to obtain a new array without duplicates.

Example

tabMonTableau is array of int = [ 1, 2, 3, 1, 4, 5, 2, 6 ]
// tabMonTableau contient [ 1, 2, 3, 1, 4, 5, 2, 6 ]

tabMonTableau.DeleteDuplicate()
// tabMonTableau contient [ 1, 2, 3, 4, 5, 6 ]

// Utilisation avec un tableau de structures
stUneCatégorie is Structure
	CODE_CATEGORIE is string(5)
	CATEGORIE is string(300)
END
tabLesCatégories is array of stUneCatégorie

// Code de remplissage du tableau
...

// Suppression des doublons
tabLesCatégories.DeleteDuplicate(asMember, "CODE_CATEGORIE;CATEGORIE")

Syntax

Deleting the duplicates from a one-dimensional array of simple elements Hide the details

<WLanguage array>.DeleteDuplicate([<Deletion options>])

<WLanguage array>: Array

Name of the Array variable to use. This array must be a one-dimensional array.
This array can also correspond to an array of simple elements of an advanced variable ("Group" array in the gglContact variables for example).

<Deletion options>: Optional integer constant

Deletion options corresponding to one or more constants:
tccIgnoreAccent Delete duplicates ignoring accents.
This option is useful for arrays of strings.
tccIgnoreCase Delete duplicates ignoring case.
This option is useful for arrays of strings.
tccIgnoreInsideSpace Delete duplicates ignoring spaces inside strings.
This option is useful for arrays of strings.
tccIgnorePunctuationAndSpace Delete duplicates ignoring spaces and punctuation.
This option is useful for arrays of strings.
tccIgnoreSpace Delete duplicates ignoring the spaces at the beginning and at the end of strings.
This option is useful for arrays of strings.

Deleting duplicates in a one-dimensional array with a comparison procedure Hide the details

<WLanguage array>.DeleteDuplicate(<asFunction> , <Custom WLanguage procedure>)

<WLanguage array>: Array

Name of the Array variable to use. This array must be a one-dimensional array.
This array can be an array of advanced types.

<asFunction>: Constant

ttFunction: Constant used to manipulate a one-dimensional array with a sorting procedure.

<Custom WLanguage procedure>: Character string

WLanguage procedure in the following format:
PROCEDURE <Procedure name>(<Element1>, <Element2>)
This procedure is automatically called by the deletion mechanism to compare the elements between themselves, two by two.
If the element 1 must be found before the element 2 in the sort order, the procedure must return -1.
If the element 1 must be found after the element 2 in the sort order, the procedure must return 1.
If element 1 and element 2 are identical, the procedure must return 0.

Remarks

This function is not available for the fixed arrays.
This function can be used on the arrays of advanced variables.
Dynamic array of variants: Only custom deletion (with a WLanguage procedure) can be used.

Component: wd300vm.dll