cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AClerk Member
Member

Filter according to first letter of text (REGEX?)

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

3 REPLIES 3
AClerk Member
Member

Re: Filter according to first letter of text (REGEX?)

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

Super User
Super User

Re: Filter according to first letter of text (REGEX?)

Hi @AClerk 

 

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

Did I answer your question? Mark my post as a solution and also give KUDOS !

Proud to be a Datanaut!
Highlighted
AClerk Member
Member

Re: Filter according to first letter of text (REGEX?)

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