Manage Learn to apply best practices and optimize your operations.

# Counting unique elements in a text list

## This tip's formula will count the number of elements that are the same in a text list.

The following formula will count the number of elements that are the same in a text list.

```List1 :=  @Explode ( "Red,Blue,Red,
Green,Red,Blue"; "," ) ;
List2 := List1 + "@" ;
List3 := @Unique ( List1 ) ;
List4 := @ReplaceSubstring
( List3; List1; List2 ) ;
List5 := @ReplaceSubstring
( List4; List3; "" ) ;
@Length ( List5 )
```

In this example it returns 3; 2; 1. That is, there are 3 occurrences of red, 2 blue and 1 green.

### How it works

List1 can be any text list field or variable.

List2 is all the elements of List1 with @ appended to the end. You can use other characters. So, in this example, List2 looks like:

``` [email protected]; [email protected]; [email protected]; [email protected]; [email protected]; [email protected]
```

List3 is a text list of the unique values within List1:

``` Red; Blue; Green
```

List4 replaces the values in List3 with those in List2, which results in an @ sign for each occurrence:

``` [email protected]@@; [email protected]@; [email protected]
```

List5 removes the List3 values from List4 and returns:

``` @@@; @@; @
```

The last command now returns the length of each item in the list:

``` 3; 2; 1
```

With a bit more list manipulation you can return:

Red 3
Blue 2
Green 1

```List1 :=  @Explode ( "Red,Blue,Red,
Green,Red,Blue"; "," ) ;
List2 := List1 + "@" ;
List3 := @Unique ( List1 ) ;
List4 := @ReplaceSubstring ( List3;
List1; List2 ) ;
List5 := @ReplaceSubstring ( List4;
List3; "" ) ;
@Length ( List5 )
```

Do you have comments on this tip? Let us know.

#### Dig Deeper on Lotus Notes Domino Formula Language

• Favorite iSeries cheat sheets

Here you'll find a collection of valuable cheat sheets gathered from across the iSeries/Search400.com community. These cheat ...

• HTML cheat sheet

This is a really cool cheat sheet if you're looking to learn more about HTML. You'll find just about everything you every wanted ...

• Carol Woodbury: Security

Carol Woodbury

Close