filter the cell containing the same format

[feiwang]

Hi,

I have a question on filtering one of my data columns as below, how can I just filter certain rows start with the first 6 account numbers?

Assets
10 - Current Asset
101 - Cash
101100 - Chase - Checking (6765)
101200 - Chase - Money Market (5452)
101300 - Chase - Payroll (9624)
101350 - Chase - Lockbox (1798)
101400 - Treasury Partners
101500 - UBS
101600 - Wells Fargo
Total 101 - Cash
105 - Short Term Investments
105100 - TP - ST Investments

[JosephSerpis · Accepted solution]

Hi @feiwang you can use the regex tool to identify the rows with 6 account numbers then just filter accordingly. 

[MichalM · Accepted solution]

@feiwang 

You can use the Regex Match tool to achieve this

(\d{6}).*

[feiwang]

Thank you so much! it's incredible!