Yadda za a raba a manyan CSV fayil zuwa mahara fayiloli?

CSV fayil ne Excel fayil. Wannan shi ne daidai shirin cewa zai iya jimre kawai tare da wata babbar yawan ayyuka da cewa mutane da fuska a kowace rana. A duban farko, kuma zai iya ze cewa Excel tebur ne iyaka, amma a gaskiya shi ne ba, kuma shi zai zama quite wuya ga wani sauki mai amfani don tabbatar da shi. Amma idan kai ne a nan, kuma an karanta wannan labarin, sa'an nan ka gane daidai da abin da zai iya zama a cikin al'amarin.

Mẽne ne a gare

Me ne fasaha na rarraba wani babban CSV fayil zuwa dama karami su da amfani? Excel yana da kadan a kan miliyan layuka da kuma ginshikan a arsenal, kuma idan ka kalli takardar, zai iya ze wuya a cika shi gaba ɗaya, amma a gaskiya shi ne sauki fiye da yadda kuke zato.

Bari mu kwatanta halin da ake ciki: ku mallaki wani fairly manyan kasuwanci da ake dangantawa da tallace-tallace ko na arziki na wani sabis. Za ka yi aiki mai kyau adadin lokaci, don haka kana da babban abokin ciniki tushe na adiresoshin imel da kuma sunayen a ka dashi. Ka yi nasarar shigo da CSV fayil da ka gane cewa cikin dukan tebur ne full. Abin da ke gaba?

Sa'an nan ya zo da fahimtar cewa manajan da irin wannan babbar tebur ne da wuya sosai, ko da idan ka san dukan tricky Excel dabaru, san yadda za a yi amfani da tacewa da dabarbari. Ko akwai iya zama irin wannan halin da ake ciki da cewa wani aiki da ka irin fayil, wani lokacin shi yiwuwa ko da wuce iyaka idan an halitta a cikin wasu sauran shirin.

A farko hanya ne zuwa tsaga ta amfani da shirin

Akwai wani adadi mai yawa na shirye-shirye a kan Internet da suke iya jimre tsagawa a manyan CSV fayil zuwa dama kananan wadanda, amma ba dukan su ba daidai jimre da aiki, don haka za mu tattauna ne kawai mafi kyau shirye-shirye daga wannan category a cikin wannan labarin.

1. Free Kato CSV Splitter.

Wannan shirin yana dauke su da asali ga kayan aiki tsagawa CSV fayiloli. Yana aiki a cewar wani mai sauqi qwarai manufa: kana bukatar ka zaɓi fayil cewa kana so ka tsaga, da kuma saka da yawan Lines cewa kana so ka yi amfani da, sa'an nan kuma danna Tsaga fayil button.

2. CSV Splitter.

Wannan shirin aiki a kan wannan manufa kamar yadda na farko, tare da kawai bambancin da cewa Splitter yana da dan kadan smoother zane, ko da yake a wasu sauki daga farko shirin zai iya ze more dace a lokacin da yin irin wannan aiki.

Na biyu hanyar da aka yin amfani da wani tsari fayil

Wannan wani zaɓi ne kadan fiye da wuya fiye da na farko, don haka yana da muhimmanci sosai ga bin share umarnin a nan.

Bayan ta amfani da tsari fayil, kana bukatar ka ƙirƙiri wani programmable tsari fayil. Don yin wannan, kana bukatar ka ƙirƙiri da kuma bude wani sabon rubutu daftarin aiki, rubuta da wadannan:

@echo off
setlocal ENABLEDELAYEDEXPANSION
REM Edit this value to change the name of the file that needs splitting. Include the extension.
SET BFN=HCAHPSHospital.csv
REM Edit this value to change the number of lines per file.
SET LPF=2500
REM Edit this value to change the name of each short file. If will be followed by a number indicating where it is in the list.
SET SFN=HosptialSplitFile
REM Do not change beyond this line.
SET SFX=%BFN:~-3%
SET /A LineNum=0
SET /A FileNum=1
For /F “delims==” %%1 in (%BFN%) Do (
SET /A LeneNum+=1
echo %%1 >> %SFN%!FileNum! .%SFX%
if !LineNum! EQU !LPF! (
SET /A LineNum=0
SET /A LineNum+=1
)
)
endlocal
Pause

Amma kai ka lokaci, domin ka bukatar ka saita da tsari fayil kafin fara. Don gane da yadda wannan ayyuka, kana bukatar ka fahimci me ya sa da kuma yadda kowane umurni da aka yi amfani a sama ayyukansu.

SET BFN ne mai matukar muhimmanci umurnin saboda shi ƙayyade CSV fayil a tsaga.

A SET LPF umurnin za nuna yadda mutane da yawa Lines zai kasance a cikin sabon fayil.

SET SFN ne ke da alhakin yadda sabon tsaga fayiloli za a mai suna.

Yanzu bari tafi a kan ga fun part - ta amfani da sakamakon fayil. Don yin wannan, danna fayil> Ajiye As> zaɓi wani sunan fayil. Bayan da cewa, zaɓi guda fayil ka kuma danna F2 button, wannan zai sa ya yiwu don canja format na wannan fayil daga .txt zuwa .bat. A gargadi zai bayyana, kana bukatar ka yarda da kuma danna OK.

Bayan ya biyo bayan wadannan matakai waɗanda zaku iya samun nasarar raba fayil ɗin CSV cikin ƙananan fayiloli.

Hanya ta uku ita ce ta amfani da rubutun powershel

Tabbas, zaku iya amfani da hanyar da ta gabata ta amfani da fayilolin Batch don rarrabe manyan fayilolin CSV, amma ya cancanci sanin cewa rubutun Powershall suna da sauri kuma mafi dacewa, kuma ya fi dacewa da manyan majalissar.

Da farko, mai amfani yana buƙatar shiga menu na Windows na Musamman. Don yin wannan, dole ne ya danna maɓallin haɗin maɓallin Ctrl + R. Menu ɗin da ke buɗe zai ƙunshi Powerhall. Idan saboda wasu dalilai wannan hanyar ba ta yi aiki ba, to, za ku iya shiga cikin Powershel kai tsaye a cikin Barikin Bincike a Fara kuma zaɓi mafi kyawun wasa. Bayan haka, kuna buƙatar rubuta rubutun masu zuwa:

$InputFilename = Get-Content ‘C:filelocation’
$0outputFilenamePattern = ‘output_done_’
$LineLimit = 50000
$line = 0
$i = 0
$file = 0
$start = 0
while ($line -le $InputFilename . Length) {
if ($i -eq $LineLimit -Or $line -eq $InputFilename.Lenght) {
$file++
$Filename = “$OutputFilenamePattern$file.csv”
$InputFilename[$start..($line-1)] | Out-File $Filename -Force
$start = $line;
£i = 0
Write-Host “$Filename”
}
$i++;
$line++
}

Kafin aiki tare da wannan rubutun, kuna buƙatar fahimtar cewa maimakon fine fayil ya kamata a rubuta wurin wurin CSV ɗin CSV ɗinku, wanda ke buƙatar raba.

Hanya ta huɗu ita ce amfani da piivot na wuta

A zahiri, pivot pivot ba ya raba fayilolin CSV zuwa yawancin ƙarin fayiloli da yawa; Hanyar da yake aiki ta dandana.

Don amfani da shi, kuna buƙatar loda fayil ɗin CSV don Excel, sannan kuma amfani da wannan shirin don buɗe shi. Sai dai itace cewa, a zahiri, ba a raba fayil ɗin, ya kasance guda ɗaya ba, amma a lokaci guda, ta amfani da shirin, yana yiwuwa a karkatar da iyakokin layin miliyan. Ku yi imani da shi ko a'a, wasu mutanen da suka yi amfani da wannan zabin sun sanya hoton allo a kan tattaunawar, wanda ya nuna layuka miliyan biyu a Excel.

Hanya ta biyar ita ce amfani da sabis na kan layi don raba fayilolin CSV

Idan baku son magance rubutun da bazai zama kamar mafi sauki ga kowa ba, zaku iya amfani da masu raba CSV na kan layi kyauta.

Daya daga cikin wadannan ayyukan ya raba CSV. Yana aiki daidai da shirye-shiryen farko na farko, wanda aka tattauna a sama, tare da kawai bambanci cewa duk aikin yana faruwa akan Intanet, kuma ba a kwamfutar da kanta.

Shirin gaba daya kyauta ne don amfani, kuma ta amfani da HTML5, ana yin duk lissafin kuɗi akan kwamfutarka. Ba a ɗora bayananku ta hanyar yanar gizo ba, kuma fayil ɗin CSV ɗinku za'a iya yanke shi cikin ƙananan chunker a kwamfutarka.

• Sabis ɗin CSV na kyauta na yanar gizo yana da ayyuka masu zuwa:
• Zabi yawan layin kan kunne;
• Zabi yawan layin da ke cikin shafi bayan CSV ya tsage.

A taƙaice: Menene hanyoyi da yawa don raba fayil ɗin CSV?

Idan kuna da manyan fayilolin CSV da yawa waɗanda ba za a iya buɗe ko cikakken ɗora ba saboda isa ga mafi yawan adadin ginshiƙai da layuka na Microsoft, to, kuna buƙatar raba fayil ɗin CSV.

Akwai wasu software na tsararren software mai rarrafe da kayan aikin yanar gizo da kayan aikin kan layi waɗanda za a iya amfani da su don raba fayiloli.

Don haka, mun sami masaniya guda biyar ba masu rikitarwa da za ku iya sauƙi kuma a sauƙaƙe raba babban fayil ɗin CSV ba, har ma har ma suna iya buɗe yadda ake buɗe ta amfani da shirin.

Tambayoyi Akai-Akai

Shin zai yiwu a yi amfani da rubutun powershell don raba fayilolin CSV?

Ee, zaku iya amfani da rubutun powershall don raba fayiloli. Wannan hanyar za ta yi sauri sosai kuma ta fi dacewa, kuma ta fi dacewa da ginin zamani.