Momwe mungasewere ndime ndi mawu okhazikika mu Excel

Tsoka ilo, kunja kwa bokosilo, sikutheka kusefa deta ndi mawu okhazikika mu Excel.Ndingakhale wokondwa momwe tingagwiritsire ntchito zosefera zotere pogwiritsa ntchito mafomu, koma izi sizikhalanso njira yathu.

Momwe mungasewere ndime ndi mawu okhazikika mu Excel Office 365

Muofesi iyi, zonse ndizoyipa kwambiri kuposa Microsoft Office wamba, ndipo kusefa ndi mawu okhazikika sikungagwirenso ntchito m'njira yosavuta.

Momwe mungasewere ndime ndi regex mu OpenOffice

OpenOffice imagwira ntchito yabwino kwambiri yosefa ndime yokhala ndi mawu okhazikika.

Momwe mungasewere ndime ndi mawu okhazikika mu LibreOffice

Monga OpenOffice, LibreOffice imatha kukonza ndime ndi mawu okhazikika.Chabwino, mukufuna chiyani, ikakhala code base imodzi.

Momwe mungasewere ndime yokhala ndi mawu okhazikika mu MyOffice

Ndikufuna kutcha office suite iyi kope lodziwika bwino la masipudishiti

Momwe mungasewere ndime ndi regex mu OnlyOffice

Ofesi yokongola kwambiri m'malingaliro mwanga, koma osati yogwira ntchito kwambiri, ndipo ndithudi mu OnlyOffice ndizosatheka kupanga fyuluta ndi mawu okhazikika.

Momwe mungasewere ndime yokhala ndi mawu okhazikika mu Google Docs

Ndikuganiza kuti mu Google docs spreadsheets ndizotheka kusefa ndime yokhala ndi mawu okhazikika, koma sindinapambane, ngakhale ndidayesa njira zambiri, koma ndidachita cholakwika.Panalibe njira yamatsenga.Munthu wosavuta sangaphunzire bwino zosefera mu Google Docs, kotero ine molimba mtima ndikuthetsa izo, komabe pali mwayi.

Momwe mungasewere ndime ndi regex mumapepala a Zoho

Sizingatheke.Zoho pamlingo wa Office 365, mawonekedwe akale kwambiri potengera kusefa mumzere.

Momwe mungasewere ndime yokhala ndi mawu okhazikika mu Yandex Office

Yandex Office imachokera ku Microsoft Office 365, kotero palibe chomwe chimagwira ntchito pamenepo))

Momwe mungasewere ndime yokhala ndi mawu okhazikika muofesi ya Mail.ru

Ayi, zimachokera ku MyOffice product

Momwe mungasewere mzere ndi regex mu Ethercalc

Sizingatheke.Ichi ndi chinthu chophikidwa theka cha ma geek, zoyipa zomwe ndidaziwonapo

Momwe mungasewere ndime ndi mawu okhazikika mu OffiDocs

Poika deta, chirichonse chinagwa.Palibe kusanja apa.Maloto owopsa.

Kusefa ndime yokhala ndi mawu okhazikika pogwiritsa ntchito zilankhulo zamapulogalamu

Tiyeni tiwone momwe tingasefe deta muzagawo pogwiritsa ntchito zilankhulo zopanga mapulogalamu.Ndidzanena nthawi yomweyo kuti palibe zoletsa m'zinenero zamapulogalamu, m'chinenero chilichonse chomwe chimakhala ndi mawu okhazikika ndizotheka kusefa ndime ya tebulo ndi mawu okhazikika.Koma mwachitsanzo, palibe mawu okhazikika ku LUA, kotero ngakhale pamenepo sizingagwire ntchito.Tiyerekeze kuti tebulo lathu lasungidwa mufayilo ya 1.csv, ndikuyesa kusefa ndi mawu okhazikika.

Zitsanzo za 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

Momwe mungasewere ndime ndi regex mu PHP

Chitsanzo cha PHP chosefa ndime yokhala ndi mawu okhazikika:

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

Pali zosankha zambiri zogwiritsira ntchito ntchitoyi mu PHP.

Momwe mungasewere gawo ndi regex mu AWK

Mwina yankho lalifupi kwambiri pa AWK.

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

AWK idachita ntchito yabwino yosefa gawo loyamba ndikuyika zonse bwino mufayilo yatsopano.