Otu esi enyocha kọlụm site na nkwupụta oge niile na Excel

N'ụzọ dị mwute, site na igbe ahụ, ọ gaghị ekwe omume iji nkwupụta oge niile na Excel nyochaa data.Ọ ga-atọ m ụtọ ka m ga-esi mejuputa nzacha dị otú ahụ site na iji usoro, mana nke a agaghị abụkwa ụzọ anyị.

Otu esi enyocha kọlụm site na nkwupụta oge niile na Excel Office 365

N'ụlọ ọrụ a, ihe niile dị njọ karịa na Microsoft Office mgbe niile, na nzacha site na nkwupụta oge niile agaghịkwa arụ ọrụ n'ụzọ dị mfe.

Otu esi enyocha kọlụm site na regex na OpenOffice

OpenOffice na-arụ ọrụ mara mma nke nzacha kọlụm yana okwu oge niile.

Otu esi enyocha kọlụm site na nkwupụta oge niile na LibreOffice

Dị ka OpenOffice, LibreOffice nwere ike hazie kọlụm site na nkwupụta oge niile.Ọfọn, kedu ihe ị chọrọ, ozugbo ọ bụ otu koodu ntọala.

Otu esi enyocha kọlụm nwere okwu oge niile na MyOffice

Ọ ga-amasị m ịkpọ ụlọ ọrụ a ka ọ bụrụ akwụkwọ ndetu na ụwa nke akwụkwọ akụkọ, ọ naghị eme ihe ọ bụla

Otu esi enyocha kọlụm site na regex na OnlyOffice

Ụlọ ọrụ kachasị mma n'uche nke m, ma ọ bụghị nke kachasị arụ ọrụ, na n'ezie na OnlyOffice ọ gaghị ekwe omume ịme nzacha kọlụm na nkwupụta oge niile.

Otu esi enyocha kọlụm nwere okwu oge niile na Google Docs

Echere m na na Google docs spreadsheets ọ ga-ekwe omume n'ụzọ ụfọdụ iji nyochaa kọlụm na okwu mgbe niile, ma enweghị m ihe ịga nke ọma, n'agbanyeghị na m gbalịrị ọtụtụ nhọrọ, ma m mere ihe na-ezighị ezi.Enweghị usoro anwansi.Onye dị mfe agaghị ama nzacha na Google Docs, yabụ m ji obi ike mechie ya, mana enwere ohere.

Otu esi enyocha kọlụm site na regex na mpempe akwụkwọ Zoho

Ụzọ adịghị.Zoho n'ọkwa nke Office 365, njirimara mbụ na usoro nzacha data na kọlụm.

Otu esi enyocha kọlụm nwere okwu mgbe niile na Yandex Office

Yandex Office dabere na Microsoft Office 365, yabụ ọ nweghị ihe na-arụ ọrụ ebe ahụ))

Otu esi enyocha kọlụm nwere okwu mgbe niile na ụlọ ọrụ Mail.ru

Mba, ọ dabere na ngwaahịa MyOffice

Otu esi enyocha kọlụm site na regex na Ethercalc

Ụzọ adịghị.Nke a bụ ngwaahịa esiri esi ọkara maka geeks, nke kachasị njọ m hụtụrụla

Otu esi enyocha kọlụm site na nkwupụta oge niile na OffDocs

Mgbe itinye data, ihe niile dara.Enweghị nhazi ebe a.Ụrọ abalị.

Na-enyocha kọlụm nwere okwu oge niile site na iji asụsụ mmemme

Ka anyị lee ka anyị nwere ike isi nzacha data na kọlụm site na iji asụsụ mmemme.M ga-ekwu ozugbo na ọ nweghị ihe mgbochi na asụsụ mmemme, n'asụsụ ọ bụla ebe a na-ekwu okwu mgbe niile, ọ ga-ekwe omume nyochaa kọlụm tebụl na okwu mgbe niile.Mana dịka ọmụmaatụ, enweghị nkwupụta okwu mgbe niile na LUA, yabụ ọbụlagodi ebe ahụ nwere ike ọ gaghị arụ ọrụ.Ka anyị were ya na a na-echekwa tebụl anyị na faịlụ 1.csv, ma gbalịa iji okwu ọnụ mee ihe mgbe niile.

Ihe atụ 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

Otu esi enyocha kọlụm site na regex na PHP

Ọmụmaatụ PHP nke nzacha kọlụm nwere okwu oge niile:

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

Enwere ọtụtụ nhọrọ maka imejuputa ọrụ a na PHP.

Otu esi enyocha kọlụm site na regex na AWK

Ikekwe ngwọta kacha nso na AWK.

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

AWK rụrụ nnukwu ọrụ nke nzacha kọlụm mbụ na itinye ihe niile nke ọma na faịlụ ọhụrụ ahụ.