Uburyo bwo gushungura inkingi kumagambo asanzwe muri Excel

Kubwamahirwe, hanze yisanduku, ntibishoboka gushungura amakuru hamwe nibisanzwe muri Excel.Nishimiye uburyo bwo gushyira mubikorwa gushungura nkoresheje formulaire, ariko ibi ntibizaba inzira yacu.

Nigute ushobora gushungura inkingi mumagambo asanzwe muri Excel Office 365

Muri ibi biro, ibintu byose ni bibi cyane kuruta muri Microsoft isanzwe, kandi kuyungurura imvugo isanzwe nabyo ntibikora muburyo bworoshye.

Nigute ushobora gushungura inkingi kuri regex muri OpenOffice

OpenOffice ikora akazi keza ko gushungura inkingi hamwe nibisanzwe.

Nigute ushobora gushungura inkingi imvugo isanzwe muri LibreOffice

Kimwe na OpenOffice, LibreOffice irashobora gutondekanya inkingi kumvugo isanzwe.Nibyiza, urashaka iki, iyo bimaze kuba code imwe shingiro.

Uburyo bwo gushungura inkingi hamwe nimvugo isanzwe muri MyOffice

Ndashaka kwita iyi biro ya suite ikaye ya notepad kwisi yimpapuro. Ntacyo ikora

Nigute ushobora gushungura inkingi kuri regex muri OnlyOffice

Ibiro byiza cyane byo mu biro mubitekerezo byanjye, ariko ntabwo aribyo bikora cyane, kandi birumvikana ko muriOffice gusa bidashoboka gukora inkingi muyunguruzi hamwe nibisanzwe.

Nigute ushobora gushungura inkingi hamwe nibisanzwe muri Google Docs

Nibwira ko muri Google docs urupapuro rushoboka hari ukuntu bishoboka gushungura inkingi hamwe nimvugo isanzwe, ariko sinabigezeho, nubwo nagerageje guhitamo byinshi, ariko nakoze nabi.Nta formulike yariho.Umuntu woroheje ntazamenya gushungura muri Google Docs, nuko nshize amanga ndangije, ariko haracyari amahirwe.

Nigute ushobora gushungura inkingi kuri regex mumpapuro za Zoho

Nta kuntu byagenda.Zoho kurwego rwa Office 365, ibintu byibanze rwose muburyo bwo gushungura amakuru mumurongo.

Nigute ushobora gushungura inkingi hamwe nibisanzwe muri Office ya Yandex

Ibiro bya Yandex bishingiye kuri Microsoft Office 365, ntakintu rero gihari))

Nigute ushobora gushungura inkingi hamwe nimvugo isanzwe mubiro bya Mail.ru

Oya, ishingiye kubicuruzwa bya MyOffice

Uburyo bwo gushungura inkingi kuri regex muri Ethercalc

Nta kuntu byagenda.Nibicuruzwa bitetse igice cya geeks, bibi cyane nabonye

Nigute ushobora gushungura inkingi mumagambo asanzwe muri OffiDocs

Iyo winjizamo amakuru, ibintu byose byaguye.Nta gutondeka hano.Inzozi.

Kurungurura inkingi hamwe nibisanzwe ukoresheje indimi

Reka turebe uko dushobora gushungura amakuru mumurongo dukoresheje indimi.Nzahita mvuga ko nta mbogamizi ziri mu ndimi za porogaramu, mu rurimi urwo ari rwo rwose ahari imvugo isanzwe birashoboka gushungura imbonerahamwe yimbonerahamwe hamwe nimvugo isanzwe.Ariko kurugero, nta mvugo isanzwe muri LUA, kuburyo na hano ishobora kudakora.Reka twiyumvire ko ameza yacu abitswe muri dosiye ya 1.csv, hanyuma tugerageze kuyungurura imvugo isanzwe.

Icyitegererezo:

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

Nigute ushobora gushungura inkingi kuri regex muri PHP

PHP urugero rwo kuyungurura inkingi hamwe nimvugo isanzwe:

<?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);

Hano hari amahitamo menshi yo gushyira mubikorwa iki gikorwa muri PHP.

Uburyo bwo gushungura inkingi kuri regex muri AWK

Ahari igisubizo kigufi kuri AWK.

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

AWK yakoze akazi gakomeye ko kuyungurura inkingi yambere no gushyira ibintu byose neza muri dosiye nshya.