Pehea e kānana ai i kahi kolamu ma ka ʻōlelo maʻamau ma Excel

ʻO ka mea pōʻino, ma waho o ka pahu, ʻaʻole hiki ke kānana i ka ʻikepili me kahi ʻōlelo maʻamau ma Excel.E hauʻoli wau i ka hoʻokō ʻana i kēlā kānana me ka hoʻohana ʻana i nā formula, akā ʻaʻole kēia ke ala.

Pehea e kānana ai i kahi kolamu ma ka ʻōlelo maʻamau ma Excel Office 365

Ma kēia keʻena, ʻoi aku ka maikaʻi o nā mea a pau ma mua o kahi Microsoft Office maʻamau, a ʻaʻole e hana maʻalahi ka kānana ʻana me kahi ʻōlelo maʻamau.

Pehea e kānana ai i kahi kolamu e regex ma OpenOffice

Hana maikaʻi ʻo OpenOffice i ka kānana ʻana i kahi kolamu me kahi ʻōlelo maʻamau.

Pehea e kānana ai i kahi kolamu ma ka ʻōlelo maʻamau ma LibreOffice

E like me OpenOffice, hiki iā LibreOffice ke hoʻokaʻawale i kahi kolamu ma kahi ʻōlelo maʻamau.ʻAe, he aha kāu makemake, i ka wā i hoʻokahi kumu code.

Pehea e kānana ai i kahi kolamu me ka ʻōlelo maʻamau i MyOffice

Makemake au e kapa i kēia keʻena keʻena he notepad ma ka honua o nā pāpalapala

Pehea e kānana ai i kahi kolamu e regex ma OnlyOffice

ʻO ka suite keʻena nani loa i koʻu manaʻo, ʻaʻole naʻe i ka hana ʻoi loa, a ʻoiaʻiʻo ma OnlyOffice ʻaʻole hiki ke hana i kahi kānana kolamu me kahi ʻōlelo maʻamau.

Pehea e kānana ai i kahi kolamu me kahi ʻōlelo maʻamau i Google Docs

Manaʻo wau aia ma Google docs spreadsheets hiki ke kānana i kahi kolamu me kahi ʻōlelo maʻamau, akā ʻaʻole i kūleʻa, ʻoiai ua hoʻāʻo wau i nā koho he nui, akā ua hana hewa wau.ʻAʻohe kumu kilokilo.ʻAʻole hiki i kahi kanaka maʻalahi ke kānana i ka Google Docs, no laila e hoʻopau wau me ka wiwo ʻole, akā aia nō kahi manawa.

Pehea e kānana ai i kahi kolamu e regex ma nā lau Zoho

Aʻole iki.ʻO Zoho ma ka pae o Office 365, nā hiʻohiʻona mua loa e pili ana i ka kānana ʻikepili i kahi kolamu.

Pehea e kānana ai i kahi kolamu me kahi ʻōlelo maʻamau ma Yandex Office

Hoʻokumu ʻia ʻo Yandex Office ma Microsoft Office 365, no laila ʻaʻohe mea e hana ma laila))

Pehea e kānana ai i kahi kolamu me kahi ʻōlelo maʻamau ma ke keʻena Mail.ru

ʻAʻole, ma muli o ka huahana MyOffice

Pehea e kānana ai i kahi kolamu e regex ma Ethercalc

Aʻole iki.ʻO kēia kahi huahana hapalua-baked no nā geeks, ka mea ʻino loa aʻu i ʻike ai

Pehea e kānana ai i kahi kolamu ma ka ʻōlelo maʻamau ma OffiDocs

I ka hoʻokomo ʻana i ka ʻikepili, hāʻule nā ​​mea a pau.ʻAʻohe hoʻokaʻawale ma ʻaneʻi.ʻO ka moeʻuhane.

Kānana i kahi kolamu me nā ʻōlelo maʻamau me ka hoʻohana ʻana i nā ʻōlelo papahana

E nānā pehea e hiki ai iā mākou ke kānana i ka ʻikepili ma kahi kolamu me ka hoʻohana ʻana i nā ʻōlelo papahana.E ʻōlelo koke wau ʻaʻohe palena o nā ʻōlelo hoʻonohonoho, ma nā ʻōlelo i loaʻa nā ʻōlelo maʻamau e hiki ke kānana i kahi kolamu papa me ka ʻōlelo maʻamau.Akā no ka laʻana, ʻaʻohe ʻōlelo maʻamau ma LUA, no laila ʻaʻole hiki ke hana ma laila.E noʻonoʻo kākou ua mālama ʻia kā mākou papaʻaina i kahi faila 1.csv, a e hoʻāʻo e kānana me kahi ʻōlelo maʻamau.

Laʻana ʻikepili:

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

Pehea e kānana ai i kahi kolamu e regex ma PHP

PHP laʻana o ka kānana ʻana i kahi kolamu me kahi ʻōlelo maʻamau:

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

Nui nā koho no ka hoʻokō ʻana i kēia hana ma PHP.

Pehea e kānana ai i kahi kolamu ma ka regex ma AWK

ʻO ka hopena pōkole loa paha ma AWK.

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

Ua hana maikaʻi ʻo AWK i ka kānana ʻana i ke kolamu mua a hoʻokomo pono i nā mea āpau i loko o ka faila hou.