Manage Learn to apply best practices and optimize your operations.

# Counting unique elements in a text list

## Formula

### Looking for something else?

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:

``` Red@; Blue@; Red@; Green@; Red@; Blue@
```

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:

``` Red@@@; Blue@@; Green@
```

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.

This was last published in November 2003

#### Start the conversation

Send me notifications when other members comment.

## SearchWindowsServer

• ### Future of Windows might involve significant weight loss

The influence of containerized applications could sway Microsoft to introduce more far-reaching refinements to Windows Server and...

IT workers need to learn how to ride the wave of innovation and master these five technologies related to Windows Server that can...

• ### Options for server management tools expand to meet IT needs

Not only do admins have to contend with a mix of server OSes, there are diverse scenarios to complicate their management. Learn ...

## Search400

• ### iSeries tutorials

Search400.com's tutorials provide in-depth information on the iSeries. Our iSeries tutorials address areas you need to know about...

• ### V6R1 upgrade planning checklist

When upgrading to V6R1, make sure your software will be supported, your programs will function and the correct PTFs have been ...

• ### Connecting multiple iSeries systems through DDM

Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed ...

## SearchDataCenter

• ### IBM Power9 servers seek market inroads to AI, cloud

IBM follows up its first Power9 server with a raft of systems designed to appeal to a wider array of markets -- most notably, AI ...

• ### Evaluate read-intensive and write-intensive SSD use cases

Consider write wear, performance and other factors when choosing between read-intensive, write-intensive and mixed-use ...

• ### Some hyper-converged infrastructure use cases pose pitfalls

Hyper-converged infrastructure adoption is skyrocketing, but that doesn't mean that the technology is the best choice for every ...

## SearchExchange

Everyone wants a smooth patching process, but things can fall apart despite everyone's best efforts. Develop a solid recovery ...

• ### New Office 365 administrators grapple with challenges

More enterprises mulling the move to Office 365 should factor in the adjustments necessary to get the IT department up to speed ...

• ### Curb stress from Exchange Server updates with these pointers

Some administrators let the memories of a bad patch linger and put off Exchange updates. Here are some tips to make this ...

## SearchContentManagement

• ### Content management in the cloud a main theme in 2018

The future of content management resides in the cloud and with AI, as several 2018 conferences will assure you.

• ### Six things to know about today's SharePoint implementations

As companies migrate their on-premises Microsoft SharePoint sites to the cloud, here are some things they should know about the ...

• ### Upgrades for the SharePoint Online portal

As more organizations migrate SharePoint sites to the cloud, Microsoft has increased at-a-glance dashboard data and analytics to ...

Close