CSV format, kana apo kuisa koma?

Pakati mafomu, akasangana kana kwete programmer, yatova imwe yepamusoro User, imupota Data kubva chikumbiro chimwe hakuitiki chaizvo kashoma. Uye kazhinji zvakafanira kupinza tabular data, izvo, chokwadi, akashandurwa sezvaari CSV format. Nomunun'una nzira dzokupedza akawanda (XML mutungamiri pakati pavo). Asi pakusikwa CSV faira, mune zvimwe zviitiko, ndiyo inonyanya nyore kugadzirisa, uye dzimwe - kupfuura matambudziko.

Zvarinomirira zita pamanyorerwo sechinhu commaseparatedvalues - vakaparadzana koma-tsika. In nebhuku rokunyorera faira sezvinotevera:

00, 01, 02, 03;

01, 15, 34, 11;

16, 27, 33, 06 (panopera chiratidzo Usaisa kuzvireva)

Uye munzvimbo Excel spreadsheet kana zvakafanana kushanda kare saka:

Asi ikozvino takakurukura nyore nyaya. Matambudziko kutanga chete nokuda chokwadi kuti nokuda compressed chaizvo mashoko nhau, CSV youduku inoshandiswa uchatamisa yakawanda mashoko. Most kazhinji Inowanikwa Databases siyana tsika: Numeric, Alpha, alphanumeric, pamwe dzezvimwe, etc. Kazhinji huru arrays vari zvikanganiso, uye kana Somuenzaniso, kumwe richava nemamwe koma mune zviri rimwe kuminda, zvose masero inogona misha nomumwe.

Kazhinji, zvinetso kana mashoko ari kutorwa nomukombiyuta faira pamanyorerwo CSV, inogona kupatsanurwa muzvikamu zvitatu:

1 - kururama zvekupfakira minda.

2 - sizvo date kutendeuka kana rokuponesa kuna CSV faira.

3 - zvisiri pamutemo chirongwa urongwa imupota.

nyaya yokutanga hatina zvishoma akaongororwa. Kuti tikurire dambudziko racho, unofanira kupa nzira vachiongorora kuti yakarurama pamusoro Data vakapinda. Somuenzaniso, kana uchida kuti vatore Database kero nokuda no list, pane chinokosha mumanyoro kuti azive kana munhu akapinda e-mail yakakodzera format. Apo pane pakakoromorwa, nezvitura befu, uye chero mamwe mashoko anogona kuverenga zvakaipa, zviri kusango inofanira akanyudzwa Taridzamutauri (vanonzi kombiyuta "").

Nyaya yechipiri chokuita kusarudza yeEncoding. Kuziva kuti iri kazhinji nevanhu chii yeEncoding vanosarudza importing chirongwa. In Windows yaiwanzoshandiswa 1251, saka kana chepakutanga faira uchasangana zvinyorwa kuna Unicode, kutevera chichagamuchirwa uratidzwe vari kuenda kushanda sezvo necheni mibvunzo. In Excel, unogona kuponesa mu CSV pamanyorerwo nedzimwe yeEncoding uye delimiter (kunze pfungwa ichiri kushandiswa Tab, uye semicolon), asi zvakanakisisa kusika faira muna nebhuku rokunyorera ++ kana OpenOfficeCalc.

nyaya wechitatu - migumisiro wechipiri. Kare, kuti CSV pamanyorerwo hauna chete mwero. Zvirongwa zvizhinji anonzwisiswa sezvo CSV uye TSV file (Tab-delimited) uye SCSV (dzakaparadzaniswa semicolons), zvikurukuru nokuti faira chiwedzerwa haisi yakashuma nezvazvo. Muchiitiko chino, mashoko ari kuverenga zvisiri uye haana dzinounzwa pakati masero ari nenhevedzano. Chinhu chakanakisisa tinogona mazano - kusika munhu CSV faira pachake. Sezvambotaurwa, inoda kushandisa imwe mupepeti.

Mazano kuti ungapingudza CSV format, anozivikanwa programmers. Simple mushandisi anofanira kuomerera kurumbidza edu kusika faira. Muduku zvose matambudziko kunoitika apo faira akasikwa zvakananga kuti zvainoreva chairo kushanda (uye dzimwe nguva nenzira yakasiyana). Zviri nyore kufunga zvinobvira matambudziko ose nawo mashoko.