How to filter a column by regular expression in Excel

Unfortunately, out of the box, it is not possible to filter data with a regular expression in Excel.I would be glad how to implement such filtering using formulas, but this will no longer be our way.

How to filter a column by regular expression in Excel Office 365

In this office, everything is much worse than in a regular Microsoft Office, and filtering by a regular expression will also not work in a simple way.

How to filter a column by regex in OpenOffice

OpenOffice does a pretty good job of filtering a column with a regular expression.

How to filter a column by regular expression in LibreOffice

Like OpenOffice, LibreOffice can sort a column by a regular expression.Well, what do you want, once it was a single code base.

How to filter a column with regular expression in MyOffice

I would like to call this office suite a notepad in the world of spreadsheets. It does nothing

How to filter a column by regex in OnlyOffice

The prettiest office suite in my opinion, but not the most functional, and of course in OnlyOffice it is impossible to make a column filter with a regular expression.

How to filter a column with a regular expression in Google Docs

I think that in Google docs spreadsheets it is somehow possible to filter a column with a regular expression, but I did not succeed, although I tried a lot of options, but I did something wrong.There was no magic formula.A simple person will not master filtering in Google Docs, so I boldly put an end to it, but still there is a chance.

How to filter a column by regex in Zoho sheets

No way.Zoho at the level of Office 365, completely primitive features in terms of filtering data in a column.

How to filter a column with a regular expression in Yandex Office

Yandex Office is based on Microsoft Office 365, so nothing works there))

How to filter a column with a regular expression in Mail.ru office

No, it's based on the MyOffice product

How to filter a column by regex in Ethercalc

No way.This is a half-baked product for geeks, the worst I've ever seen

How to filter a column by regular expression in OffiDocs

When inserting data, everything fell.No sorting here.Nightmare.

Filtering a column with regular expressions using programming languages

Let's look at how we can filter data in a column using programming languages.I will say right away that there are no restrictions in programming languages, in any language where there are regular expressions it is possible to filter a table column with a regular expression.But for example, there are no regular expressions in LUA, so even there it may not work.Let's imagine that our table is stored in a 1.csv file, and try to filter with a regular expression.

Sample data:

egais-sochi.ru;0;0;2016-03-29;2022-04-29;1
egewithsasha.ru;0;0;2021-03-29;2022-04-29;1
ego-logic.ru;0;0;2021-03-29;2022-04-29;1
egologic.ru;0;0;2021-03-29;2022-04-29;1
eight-8.ru;0;0;2021-03-29;2022-04-29;1
eight8.ru;0;0;2006-06-30;2022-04-29;1
ekb-crystal.ru;0;0;2021-03-29;2022-04-29;1
eko-stoun.ru;0;0;2021-03-29;2022-04-29;1
eko4u.ru;0;0;2008-04-01;2022-04-29;1
ekodrive.ru;0;0;2009-09-01;2022-04-29;1

How to filter a column by regex in PHP

PHP example of filtering a column with a regular expression:

<?php
$lines = file ( '1.csv' );
$OUT='';
foreach ($lines as $line) {
    $items = explode(";", $line);
    if (!preg_match("#[0-9]#", $items[0]))
        $OUT.=$line;
}
file_put_contents("2.csv",$OUT);

There are a lot of options for implementing this task in PHP.

How to filter a column by regex in AWK

Perhaps the shortest solution on AWK.

awk -F";" "$1!~/[0-9]/ {print}" 1.csv > 3.csv

AWK did a great job of filtering the first column and putting everything neatly into the new file.