How to filter data by column with regular expressions.15 ways

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.





bg bs ca ceb co cs cy da de el en eo es et fa fi fr fy ga gd gl gu ha haw hi hmn hr ht hu id ig is it iw ja jw ka kk km kn ko ku ky la lb lo lt lv mg mi mk ml mn mr ms mt my ne nl no ny or pa pl ps pt ro ru rw sd si sk sl sm sn so sr st su sv sw ta te tg th tk tl tr tt ug uk ur uz vi xh yi yo zh zu
Text to speech
QR-Code generator
Parsedown cheatsheet. Markdown
Filter data by column with regular expressions
Engines for creating games on LUA ?
JavaScript: draw a point
JavaScript: Speaking text in Chinese