CSV files are funny animals.If I open/read the file as a text stream, and try
to parse each line using a comma (,) delimiter,I get a different result than if
I were to open the .csv file in excel.
Consequently, what I've done in the past is read the file and write the line to
another .csv file w
Then you can try the tool, which you can download from below URL.
You have to mention the rows like you want to split the file after 10 lacs
rows.
http://download.cnet.com/CSV-Splitter/3000-2074_4-75910188.html
On Wed, Apr 20, 2016 at 10:13 AM, Mahesh wrote:
> yes, it is .csv
>
> On Tue, Apr 19
yes, it is .csv
On Tue, Apr 19, 2016 at 10:18 PM, Devendra Sahay <
devendrasahanypt...@gmail.com> wrote:
> Hi Mahesh,
>
> Please confirm the file format, is it .csv
>
>
>
>
> On Tue, Apr 19, 2016 at 10:16 PM, Mahesh wrote:
>
>> Hi,
>>
>> I want to split it by rows.
>>
>> For example-
>> if the t
Hi Mahesh,
Please confirm the file format, is it .csv
On Tue, Apr 19, 2016 at 10:16 PM, Mahesh wrote:
> Hi,
>
> I want to split it by rows.
>
> For example-
> if the text file contains 12 lacs rows, then I would like make 03
> different text files with 4lacs row in each one of them.
> On Apr
Hi,
I want to split it by rows.
For example-
if the text file contains 12 lacs rows, then I would like make 03 different
text files with 4lacs row in each one of them.
On Apr 19, 2016 5:48 PM, "Paul Schreiner" wrote:
> What criteria do you want to divide between the files?
> How do you want to
Hi,
Try this one.
http://download.cnet.com/CSV-Splitter/3000-2074_4-75910188.html
On Tue, Apr 19, 2016 at 5:48 PM, Paul Schreiner
wrote:
> What criteria do you want to divide between the files?
> How do you want to split it into columns?
>
> It is fairly easy to write a VBA macro that will o
What criteria do you want to divide between the files?How do you want to split
it into columns?
It is fairly easy to write a VBA macro that will open the text file and read it
line-by-line.then, depending on your criteria, write the line to an Excel
workbook or simply separate sheets in a singl
