Beddelaha JSON ilaa CSV oo Bilaash ah

Sida Ay U Shaqeyso

Qalabkani wuxuu u beddelaa JSON iyo CSV dhexdiisa gebi ahaanba biraawsarkaaga isagoo isticmaalaya eber laybreri dibadeed ah — habka beddelku waa TypeScript gacan lagu qoray oo gudaha ka shaqeeya. Falanqaynta JSON waxay isticmaashaa JSON.parse ee biraawsarka dabiiciga ah, halka falanqaynta CSV ay isticmaasho state-machine RFC 4180 oo gaar ah oo maareeya xaaladaha gees ee beddelayaasha fudud badankoodu si khaldan u qabtaan.

1. 1
   JSON waa la falanqeeyay furayaashana waa la ururiyay

   JSON.parse() wuxuu akhriyaa gelitaanka waxaana xaqiijiyaa inuu yahay array. Beddelahu kadibna wuxuu maraa shay kasta oo array-ka ku jira si uu u dhiso isku-dar dhammaan furayaasha — sidaa darteed arrays sparse ah oo safafku leeyihiin goobo kala duwan waxay wali soo saaraan saf madax oo dhammaystiran.
2. 2
   Fudaynta shayga geli-geli ah ee ikhtiyaarka ah

   Haddii ikhtiyaarka fudaynta shidan yahay, shayaal geli-geli ah sida {"address":{"city":"Oslo"}} waxaa isdaba-joog loo soo koobaa tiirar dot-notation ah (address.city) ka hor inta madaxyada la dhisin. Arrays iyo shayaal madhan waxaa loo hayaa qiyam unug JSON-stringified ah.
3. 3
   Sumaynta unugyada oo la jaanqaaday RFC 4180 oo leh dhexdhexaadinta qaaciddada

   Qiime unug kasta waxaa loo escape-gareeyaa sida RFC 4180: goobaha ka kooban comma, sumado-qaawan-laba-geesood ah, ama khadad cusub waxaa ku duuban sumado-qaawan-laba-geesood ah, sumadaha gudaha ahna waa la laba-geesaystaa. Habka Soo-saarka Ammaanka ah (default ahaan shidan) sidoo kale wuxuu horgale u dhigaa unug kasta oo ku bilaabma =, +, -, ama @ sumad-qaawan hal-geesood ah, taasoo ka hortagaysa in apps xaashi-xisaabeedka sida Excel ama Google Sheets ay u qaataan qiyamka la geliyay qaacido la fulin karo.
4. 4
   CSV-ilaa-JSON wuxuu isticmaalaa state-machine heer-xaraf ah

   Jiho rogan, function-ka la wadaago ee parseCsv wuxuu maraa gelitaanka xaraf-xaraf, isagoo la socda inuu ku jiro goob qaawan si sax ah u maareeyo comma ku duuban, sumado-qaawan-la-escape-gareeyay (""), iyo khadad cusub oo ku jira unugyada — kiisaska habka fudud ee kala-jarka khadku si khaldan u maareeyo. detectDelimiter wuxuu shanshaneeyaa safka koowaad comma, semicolon, tab, ama pipe si loo taageero soo-saarka nooca aan caadiga ahayn si toos ah.

Qalabka La Xiriira