There are some questions alike in this site, but mine is a bit different.
I have a 30 GB text file, and I need to split it into smaller files according to the different record values.
For example;
NAME DATE AMOUNT
AA 02.03.2014 768,30
AA 03.03.2014 234,15
BB 12.01.2014 238,00
BB 15.09.2014 567,00
BB 06.12.2014 323,00
CC 08.02.2015 456,00
CC 09.02.2015 213,00
into ---->
AA.TXT
NAME DATE AMOUNT
AA 02.03.2014 768,30
AA 03.03.2014 234,15
BB.TXT
NAME DATE AMOUNT
BB 12.01.2014 238,00
BB 15.09.2014 567,00
BB 06.12.2014 323,00
CC.TXT
NAME DATE AMOUNT
CC 08.02.2015 456,00
CC 09.02.2015 213,00
Here I've found a clue, but I barely know Powershell scripting, so I couldn't figure out a way to split files according to the NAME value.
In the answer which I've cited above, it seeks for a bracket [
, what I seek is a different value from the one above in the NAME column.
AND;
Smaller files in .txt formats will do the job BUT the following is appreciated:
--If row count is < 1.000.000 , then extract the records into a .xls (or .xlsx) file.
Any solutions in any other languages are also welcomed.
Thanks.