Ngelishwa, ngaphandle kwebhokisi, akunakwenzeka ukucoca idatha ngokuchazwa rhoqo kwi-Excel.Ndingavuya ukuba kwenziwa njani na ukuhluza usebenzisa iifomula, kodwa oku akusayi kuba yindlela yethu.
Kule ofisi, yonke into imbi kakhulu kuneOfisi yeMicrosoft eqhelekileyo, kwaye ukuhluza ngentetho eqhelekileyo nako akuyi kusebenza ngendlela elula.
I-OpenOffice yenza umsebenzi olungileyo wokucoca ikholamu ngentetho eqhelekileyo.
NjengeOpenOffice, iLibreOffice inokulungisa ikholamu ngokwentetho eqhelekileyo.Kulungile, ufuna ntoni, xa ibisisiseko sekhowudi enye.
Ndingathanda ukubiza le office suite ngenotepad kwihlabathi lespreadsheets.Ayenzi nto
Eyona ofisi intle kakhulu ngokoluvo lwam, kodwa ayisiyiyo eyona isebenzayo, kwaye kunjalo kwi-OnlyOffice akunakwenzeka ukwenza isihluzo sekholamu ngentetha eqhelekileyo.
Ndicinga ukuba kwi-spreadsheets ze-Google docs ngandlela-thile kunokwenzeka ukucoca ikholamu ngentetho eqhelekileyo, kodwa andizange ndiphumelele, nangona ndizamile ezininzi iinketho, kodwa ndenze into engalunganga.Kwakungekho fomula yomlingo.Umntu olula akazukukwazi ukusefa kwiGoogle Docs, ndiye ndayiphelisa ngesibindi, kodwa lisekhona ithuba.
Akho ndlela yimbi.I-Zoho kwinqanaba le-Ofisi 365, iimpawu zamandulo ngokupheleleyo malunga nokucoca idatha kwikholamu.
IOfisi yeYandex isekwe kwiMicrosoft Office 365, ke akukho nto isebenzayo apho))
Hayi, isekwe kwimveliso yeMyOffice
Akho ndlela yimbi.Le yimveliso ebhakwe ngesiqingatha yeegeki, eyona nto imbi endakha ndayibona
Xa ufaka idatha, yonke into yawa.Akukho kuhlelwa apha.Iphupha elibi.
Makhe sijonge indlela esinokuyihluza ngayo idatha kwikholamu sisebenzisa iilwimi zokuprograma.Ndiza kuthetha ngokukhawuleza ukuba akukho zithintelo kwiilwimi zeprogram, kulo naluphi na ulwimi apho kukho ukubonakaliswa okuqhelekileyo kunokwenzeka ukucoca ikholamu yetafile kunye nentetho eqhelekileyo.Kodwa umzekelo, akukho mabinzana aqhelekileyo kwi-LUA, ke nalapho isenokungasebenzi.Makhe sicinge ukuba itheyibhile yethu igcinwe kwifayile ye-1.csv, kwaye sizame ukuhluza ngentetho eqhelekileyo.
Idatha yesampuli:
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
Umzekelo we-PHP wokuhluza ikholamu enentetho eqhelekileyo:
<?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);
Zininzi iinketho zokuphumeza lo msebenzi kwi-PHP.
Mhlawumbi esona sisombululo sifutshane kwi-AWK.
awk -F";" "$1!~/[0-9]/ {print}" 1.csv > 3.csv
I-AWK yenza umsebenzi omkhulu wokucoca ikholamu yokuqala kunye nokubeka yonke into ngokucocekileyo kwifayile entsha.