[Solved] Grouping By Substring

[Robert]

I have a column that I'm displaying in the RadGrid which has text in the following format:

"Part1.Part2.Part3.Part4"

The number of parts is variable.

I'd love to be able to group their display in the grid based on everything but the last part in the string. For instance, consider the following values:

MyCompany.MyProduct.MyModule1.MySetting1
MyCompany.MyProduct.MyModule1.MySetting2
MyCompany.MyProduct.MyModule2.MySetting3
MyCompany.MyProduct.MyModule3.MySetting4

My grid would display like:

MyCompany.MyProduct.MyModule1
--> MyCompany.MyProduct.MyModule1.MySetting1
--> MyCompany.MyProduct.MyModule1.MySetting2
MyCompany.MyProduct.MyModule2
--> MyCompany.MyProduct.MyModule2.MySetting3
MyCompany.MyProduct.MyModule3
--> MyCompany.MyProduct.MyModule3.MySetting4

In otherwords, is there a way to create a grouping expression that grouped on a substring of the value of the column?

[Yavor]

Hello Robert,

You can only group on the actual value coming from the database. Another option would be to include a separate field/column, which contains a substring of the original value, and group on it instead.

Sincerely yours,
Yavor
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.