Kyauta Mai Canza JSON zuwa CSV

Yadda Yake Aiki

Wannan kayan aikin yana canjawa tsakanin JSON da CSV gaba ɗaya a burauzarka ta amfani da sifili na ɗakunan karatu na waje — hankalin canjawa TypeScript ne da aka rubuta da hannu wanda yake gudana a wurin nan. Nazarin JSON yana amfani da JSON.parse na asali na burauza, yayin da nazarin CSV yake amfani da wata na'ura mai yanayi na RFC 4180 na musamman wadda take sarrafa yanayoyin da yawancin masu canjawa marasa hankali suke kuskure.

1. 1
   An nazari JSON kuma an tara kanun labarai

   JSON.parse() yana karanta shigarwa kuma yana tabbatar da ita a matsayin jeri. Mai canjawa sannan yana tafiya kowane abu a jerin don gina haɗin duk maɓalli — don haka jeri da suke da kaɗan wadanda layi daban-daban suke da fannoni daban har yanzu suna samar da layin kanun labarai cikakke.
2. 2
   Rushe abu na cikin gida na zaɓi

   Idan zaɓin rushewa a kunne yake, abubuwan cikin gida kamar {"address":{"city":"Oslo"}} an rushe su maimaitawa zuwa shafuka na dot-notation (address.city) kafin gina kanun labarai. Ana barin jeri da abubuwa fanko a matsayin ƙimomin tantanin JSON-stringified.
3. 3
   Ɓoyewar tantanin mai bin RFC 4180 tare da tsaka-tsakin ka'ida

   Ana escape kowace ƙimar tantani bisa RFC 4180: filayen da suke ɗauke da waƙafi, ambaton biyu, ko sabbin layi ana lulluɓe su a ambaton biyu, kuma ana ninka ambaton na ciki. Yanayin Fitar-Lafiya (a kunne a asali) yana kuma sanya wata ambaton guda a gaban duk tantanin da yake farawa da =, +, -, ko @, yana hana app na spreadsheet kamar Excel ko Google Sheets daga ɗaukar ƙimomin da aka saka a matsayin ka'idoji masu gudana.
4. 4
   CSV-zuwa-JSON yana amfani da na'ura mai yanayi na matakin harafi

   Yin akasin alkibla, aikin parseCsv da aka raba yana tafiya shigarwa harafi-bayan-harafi, yana bin diddigin ko yana cikin filin da aka ambata don sarrafa waƙafi da aka saka, ambaton biyu da aka escape (""), da sabbin layi a cikin tantani daidai — yanayoyin da wata hanyar sauƙi ta rabawa-layi take kuskure. detectDelimiter yana bincika layi na farko don waƙafi, semicolon, tab, ko pipe don goyon bayan fitarwa marasa-al'ada kai tsaye.

Kayan Aiki Masu Alaƙa