How to display count of individual letter in a string?

[Ruchita_Patil]

Hi, I have a string “Ruchita Patil”
How can I get the following output in uipath studio in a message box?

Input: String = “Ruchita ruchi Patil”
Output: R = 2
u = 2
c = 3
h = 2
i = 3
t = 2
a = 2
P = 1
l = 1

Thanks!!

[Yoichi]

Hi,

Can you try the following sample?

dict = yourString.GroupBy(Function(c) c.ToString.ToUpper).ToDictionary(Function(g) g.Key,Function(g) g.Count)

Sequence.xaml (6.7 KB)

Regards,

[Ruchita_Patil]

Hi, thank you so much for the help!!
Also, could you please tell me what code language is that and where can I learn it?

[Yoichi]

Hi,

It’s LINQ (for VB). The following topic will help you.

[HowTo] - First Start with LINQ (VB.Net)

LINQ is part of the .NET framework and offers capabilities for interacting with data, objects or other sources within a particular syntax. This HowTo introduces on starting with LINQ (Language-Integrated Query). Current Version of this topic is DRAFT and will be finalized / enhanced soon Introduction Typical tasks for implementing parts of an automation project are interacting with e.g. with data in a datatable or items from collections. LINQ can help to implement it into a compact and standa…

And we can also write it without LINQ as the following.

Hope this helps you.

Regards,