Maitiro ekusefa koramu nekutaura nguva dzose muExcel

Nehurombo, kunze kwebhokisi, hazvigoneke kusefa data neyakajairwa kutaura muExcel.Ndingafara sei kuita kusefa kwakadaro uchishandisa mafomula, asi iyi haichave nzira yedu.

Maitiro ekusefa koramu nekutaura nguva dzose muExcel Hofisi 365

Muhofisi ino, zvese zvakanyanya kuipa kupfuura muMicrosoft Office yenguva dzose, uye kusefa nekutaura nguva dzose hakuzoshande nenzira iri nyore.

Maitiro ekusefa koramu ne regex muOpenOffice

OpenOffice inoita basa rakanaka rekusefa koramu ine chirevo chenguva dzose.

Maitiro ekusefa koramu nekutaura nguva dzose muLibreOffice

Kufanana neOpenOffice, LibreOffice inogona kugadzirisa koramu nekutaura kwenguva dzose.Zvakanaka, unodei, kana yave imwe kodhi base.

Maitiro ekusefa koramu ine nguva dzose kutaura muMyOffice

Ndinoda kufonera office ino kuti notepad munyika yemaspreadsheets

Maitiro ekusefa koramu ne regex muOlyOffice

Iyo yakanakisa hofisi suite mumaonero angu, asi isiri iyo inonyanya kushanda, uye hongu muCheteOffice hazvibviri kuita sefa yekoramu ine chirevo chenguva dzose.

Maitiro ekusefa koramu ine chirevo chenguva dzose muGoogle Docs

Ini ndinofunga kuti muGoogle docs maspredishiti zvinokwanisika kusefa koramu nekutaura kwakajairwa, asi handina kubudirira, kunyangwe ndakaedza akawanda sarudzo, asi ndakaita zvakaipa.Pakanga pasina nzira yemashiripiti.Munhu ari nyore haagone kusefa muGoogle Docs, saka ini ndakazvipedza neushingi, asi pachine mukana.

Maitiro ekusefa koramu ne regex mumashiti eZoho

Hazviite.Zoho pamwero weHofisi 365, zvachose maficha maficha maererano nekusefa data mumutsara.

Maitiro ekusefa koramu ine yakajairika kutaura muYandex Hofisi

Yandex Hofisi yakavakirwa paMicrosoft Office 365, saka hapana chinoshanda ipapo))

Maitiro ekusefa koramu ine yenguva dzose kutaura muMail.ru hofisi

Kwete, zvakavakirwa pachigadzirwa cheMyOffice

Maitiro ekusefa koramu ne regex muEthercalc

Hazviite.Ichi chigadzirwa chehafu-chakabikwa che geeks, yakaipisisa yandati ndamboona

Maitiro ekusefa koramu nekutaura nguva dzose muOfiDocs

Pakuisa data, zvese zvakadonha.Hapana kurongedza apa.Hope dzakaipa.

Kusefa koramu ine mataurirwo enguva dzose uchishandisa mitauro yekuronga

Ngatitarisei kuti tingasefa sei data mukoramu tichishandisa mitauro yekuronga.Ini ndichataura ipapo ipapo kuti hapana zvirambidzo mumitauro yepurogiramu, mumutauro chero upi noupi kune mataurirwo enguva dzose zvinokwanisika kusefa tafura tafura nekutaura kwenguva dzose.Asi semuenzaniso, hapana mataurirwo akajairwa muLUA, saka kunyangwe ipapo anogona kusashanda.Ngatimbofungidzira kuti tafura yedu yakachengetwa mufaira re 1.csv, uye edza kusefa nekutaura kwenguva dzose.

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

Maitiro ekusefa koramu ne regex muPHP

PHP muenzaniso wekusefa koramu ine chirevo chenguva dzose:

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

Pane zvakawanda zvingasarudzwa zvekuita basa iri muPHP.

Maitiro ekusefa koramu ne regex muAWK

Zvichida mhinduro pfupi pane AWK.

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

AWK yakaita basa guru rekusefa koramu yekutanga nekuisa zvese zvakanaka mufaira idzva.