Filter according to first letter of text (REGEX?)

[Anonymous]

Hi All,

Following my post.

Is there a way to filter a table according to a text column and the starting letter?
I would like to filter all texts that start with a,b,c...j. Then create another table and show only text starts with k,l,m....s, and so on.

So if I have a table with names I will get in visual1 all the names that starts with a to j, in visual2 all the names that starts with k to s, and so on.

Thanks

[Anonymous]

Currently,

I am taking the UNICODE of the first letter and using it in the filters.

The column I have created is - unicode(left(table1[name],1))

Then I filter according to the above - unicode > 65 and unicode < 74 (For example for Names that starts with A to J).

Looking for a more elegant solution.

Thanks

[CheenuSing]

Hi @Anonymous 

Caan you post some data in the OneDrive / Google Drive and paste the link here.  Also let us know what is the final output you expect.

Cheers

CheenuSing

[Anonymous]

Hi @CheenuSing 

The original issue I have is a large table with multiple records that I need to show on a monitor in the office.

So lets say I have 100 records in my table, but only 30 can be shown on the screen.

How can I show the entire table?

I thouhgt to split the table into sub-tables and to show different names.

For instance, sub-table-1 will show names from A-D, sub-table-2 will show names from E-I, sub-table-3 will show names from J-O and so on...

This is a bad solution. But the only workaround I can think of right now.

Here is an example:
List of names in the main table

Alfie

Amelia

Ava

Bill

Charlie

David

Eddie

Emily

Freddie

George

Gin

Grace

Harry

Iris

Isabella

Isla

Jack

Jack

Jacob

Kai

Lily

Mia

Noah

Oliver

Olivia

Ophra

Oscar

Queen

Robby

Sophia

Tina

Victoria

Yvonne

Zoe

After split

Alfie		Eddie		Jack
Amelia		Emily		Jack
Ava		Freddie		Jacob
Bill		George		Kai
Charlie		Gin		Lily
David		Grace		Mia
		Harry		Noah
		Iris		Oliver
		Isabella		Olivia
		Isla		Ophra

I started to explore the option to create a custom visual, but couldn't find enough information about what I need and want.

Ta