Splitting .TXT files

[Guest GKW in GA]

I have a large text file that I would like to split into multiple smaller

text files of approximatley the same size. It is too large for Excel. How can

I do this aside from copy and paste in NOTEPAD

[Guest Doug Knox - [MS-MVP]]

Re: Splitting .TXT files

 

http://www.filesplitter.org/

 

--

Doug Knox, MS-MVP Windows Media Center\Windows Powered Smart

Display\Security

Win 95/98/Me/XP Tweaks and Fixes

http://www.dougknox.com

--------------------------------

Per user Group Policy Restrictions for XP Home and XP Pro

http://www.dougknox.com/xp/utils/xp_securityconsole.htm

--------------------------------

Please reply only to the newsgroup so all may benefit.

Unsolicited e-mail is not answered.

 

"GKW in GA" <GKWinGA@discussions.microsoft.com> wrote in message

news:00F2C651-DB71-4207-9355-8575534922FD@microsoft.com...

>I have a large text file that I would like to split into multiple smaller

> text files of approximatley the same size. It is too large for Excel. How

> can

> I do this aside from copy and paste in NOTEPAD

[Guest Industrial One]

Re: Splitting .TXT files

 

On Jul 10, 9:42 am, "Doug Knox - [MS-MVP]" <dkno...@Spammvps.org>

wrote:

> http://www.filesplitter.org/

 

Or a hex editor.

[Guest Ken Blake, MVP]

Re: Splitting .TXT files

 

On Thu, 10 Jul 2008 08:24:01 -0700, GKW in GA

<GKWinGA@discussions.microsoft.com> wrote:

> I have a large text file that I would like to split into multiple smaller

> text files of approximatley the same size. It is too large for Excel. How can

> I do this aside from copy and paste in NOTEPAD

 

 

 

I'm not sure why you would even want to consider using Excel for this

purpose, but what do you have against Copy and Paste (whether in

Notepad or a word processor)? It certainly seems like the simplest and

easiest way to me.

 

--

Ken Blake, Microsoft MVP - Windows Desktop Experience

Please Reply to the Newsgroup

[Guest GKW in GA]

Re: Splitting .TXT files

 

I may be mistaken but it appears that after you split the files you have to

use the tool to join them back together before you can work with them.

 

I was hoping to be able to split a large .txt file that someone sent me into

smaller .txt files and then email them back (one at at a time) so they could

open them with notepad without them having to install file splitter and join

them back together. Will this still work?

 

"Doug Knox - [MS-MVP]" wrote:

> http://www.filesplitter.org/

>

> --

> Doug Knox, MS-MVP Windows Media Center\Windows Powered Smart

> Display\Security

> Win 95/98/Me/XP Tweaks and Fixes

> http://www.dougknox.com

> --------------------------------

> Per user Group Policy Restrictions for XP Home and XP Pro

> http://www.dougknox.com/xp/utils/xp_securityconsole.htm

> --------------------------------

> Please reply only to the newsgroup so all may benefit.

> Unsolicited e-mail is not answered.

>

> "GKW in GA" <GKWinGA@discussions.microsoft.com> wrote in message

> news:00F2C651-DB71-4207-9355-8575534922FD@microsoft.com...

> >I have a large text file that I would like to split into multiple smaller

> > text files of approximatley the same size. It is too large for Excel. How

> > can

> > I do this aside from copy and paste in NOTEPAD

>

[Guest GKW in GA]

Re: Splitting .TXT files

 

I mentioned in my original post that it was too large for Excel so I was not

considering Excel.

 

I guess I could cut and paste but I was hoping to make them all about the

same size. I was going to email the file to the requestor, so due to the

limit on attachment size, if the original file was very large, I might have

to create mutiple smaller files which could be time consuming to do manually.

Therefore, I was hoping to automate it a bit.

 

"Ken Blake, MVP" wrote:

> On Thu, 10 Jul 2008 08:24:01 -0700, GKW in GA

> <GKWinGA@discussions.microsoft.com> wrote:

>

> > I have a large text file that I would like to split into multiple smaller

> > text files of approximatley the same size. It is too large for Excel. How can

> > I do this aside from copy and paste in NOTEPAD

>

>

>

> I'm not sure why you would even want to consider using Excel for this

> purpose, but what do you have against Copy and Paste (whether in

> Notepad or a word processor)? It certainly seems like the simplest and

> easiest way to me.

>

> --

> Ken Blake, Microsoft MVP - Windows Desktop Experience

> Please Reply to the Newsgroup

>

[Guest Industrial One]

Re: Splitting .TXT files

 

On Jul 10, 3:19 pm, GKW in GA <GKWi...@discussions.microsoft.com>

wrote:

> I mentioned in my original post that it was too large for Excel so I was not

> considering Excel.

>

> I guess I could cut and paste but I was hoping to make them all about the

> same size. I was going to email the file to the requestor, so due to the

> limit on attachment size, if the original file was very large, I might have

> to create mutiple smaller files which could be time consuming to do manually.

> Therefore, I was hoping to automate it a bit.

>

> "Ken Blake, MVP" wrote:

> > On Thu, 10 Jul 2008 08:24:01 -0700, GKW in GA

> > <GKWi...@discussions.microsoft.com> wrote:

>

> > > I have a large text file that I would like to split into multiple smaller

> > > text files of approximatley the same size. It is too large for Excel. How can

> > > I do this aside from copy and paste in NOTEPAD

>

> > I'm not sure why you would even want to consider using Excel for this

> > purpose, but what do you have against Copy and Paste (whether in

> > Notepad or a word processor)? It certainly seems like the simplest and

> > easiest way to me.

>

> > --

> > Ken Blake, Microsoft MVP - Windows Desktop Experience

> > Please Reply to the Newsgroup

 

Which is why you should use a hex editor. It displays the offset as

you scroll, so you know exactly where half of the file would be, or

1/4, 1/10 whatever. You can split it by hand (copy/paste) or automate

it. Your recipients should have and know how to use a hex editor. It's

a very basic tool.

[Guest Pegasus \(MVP\)]

Re: Splitting .TXT files

 

 

"Industrial One" <industrial_one@hotmail.com> wrote in message

news:25d68fc1-2106-4b7e-920c-4a67b7b6427d@t54g2000hsg.googlegroups.com...

> On Jul 10, 3:19 pm, GKW in GA <GKWi...@discussions.microsoft.com>

> wrote:

>> I mentioned in my original post that it was too large for Excel so I was

>> not

>> considering Excel.

>>

>> I guess I could cut and paste but I was hoping to make them all about the

>> same size. I was going to email the file to the requestor, so due to the

>> limit on attachment size, if the original file was very large, I might

>> have

>> to create mutiple smaller files which could be time consuming to do

>> manually.

>> Therefore, I was hoping to automate it a bit.

>>

>> "Ken Blake, MVP" wrote:

>> > On Thu, 10 Jul 2008 08:24:01 -0700, GKW in GA

>> > <GKWi...@discussions.microsoft.com> wrote:

>>

>> > > I have a large text file that I would like to split into multiple

>> > > smaller

>> > > text files of approximatley the same size. It is too large for Excel.

>> > > How can

>> > > I do this aside from copy and paste in NOTEPAD

>>

>> > I'm not sure why you would even want to consider using Excel for this

>> > purpose, but what do you have against Copy and Paste (whether in

>> > Notepad or a word processor)? It certainly seems like the simplest and

>> > easiest way to me.

>>

>> > --

>> > Ken Blake, Microsoft MVP - Windows Desktop Experience

>> > Please Reply to the Newsgroup

>

> Which is why you should use a hex editor. It displays the offset as

> you scroll, so you know exactly where half of the file would be, or

> 1/4, 1/10 whatever. You can split it by hand (copy/paste) or automate

> it. Your recipients should have and know how to use a hex editor. It's

> a very basic tool.

 

A hex editor would not appear to be the ideal tool for a file splitter

if a job is to be automated. I would go for a splitter that can be

invoked in a batch file, one that creates file fragments that can

be reassembled by the humble "copy" command.

 

To the OP: If you can't locate a suitable splitter within a day or two

then I'll let you have my VB Script-based splitter. It will run on any

Windows OS without installation and it meets all of the above

requirements.

[Guest Big_Al]

Re: Splitting .TXT files

 

GKW in GA wrote:

> I have a large text file that I would like to split into multiple smaller

> text files of approximatley the same size. It is too large for Excel. How can

> I do this aside from copy and paste in NOTEPAD

 

I have a unix set of utilities that we use for development at the office.

Split.exe in unix takes a command line argument of a file name, and a

line count, and a base output file. I have not used it in a while and

the order of arguments etc may be wrong, but the point is: ie.

 

split.exe Largefile.txt 400 output

and it will makes output files of 400 lines of text starting with

outputaa

outputab

outputac

.....

outputaz

outputba

outputbb

outputbc

....

outputbz

outputca

etc.

 

If you can find a copy of this utility it will maintain the text file

but just break it into pieces.

And a simply copy outputaa+outputab+outputac .... will put them together.

 

Disclaimer: I don't know your file or cr/lf necessity etc and how

split.exe (whatever version you get) will handle them. So there are

some variables still in this process.

[Guest Big_Al]

Re: Splitting .TXT files

 

Big_Al wrote:

> GKW in GA wrote:

>> I have a large text file that I would like to split into multiple

>> smaller text files of approximatley the same size. It is too large for

>> Excel. How can I do this aside from copy and paste in NOTEPAD

>

> I have a unix set of utilities that we use for development at the office.

> Split.exe in unix takes a command line argument of a file name, and a

> line count, and a base output file. I have not used it in a while and

> the order of arguments etc may be wrong, but the point is: ie.

>

> split.exe Largefile.txt 400 output

> and it will makes output files of 400 lines of text starting with

> outputaa

> outputab

> outputac

> ....

> outputaz

> outputba

> outputbb

> outputbc

> ...

> outputbz

> outputca

> etc.

>

> If you can find a copy of this utility it will maintain the text file

> but just break it into pieces.

> And a simply copy outputaa+outputab+outputac .... will put them together.

>

> Disclaimer: I don't know your file or cr/lf necessity etc and how

> split.exe (whatever version you get) will handle them. So there are

> some variables still in this process.

>

I found this tools.zip

I was able to take the less.man file and split it into 20 lines per file.

SPLIT -l=20 LESS.MAN OUTPUT

and this created files ouputaa outputab outputac etc. All 20 lines.

 

http://msteed.org/software/unix_on_nt/

 

See if this is what you want. Remember its for text files. And as

others have commented, somehow you are talking about excel which is

confusing us.

[Guest metspitzer]

Re: Splitting .TXT files

 

On Thu, 10 Jul 2008 13:46:02 -0700, GKW in GA

<GKWinGA@discussions.microsoft.com> wrote:

>I may be mistaken but it appears that after you split the files you have to

>use the tool to join them back together before you can work with them.

>

>I was hoping to be able to split a large .txt file that someone sent me into

>smaller .txt files and then email them back (one at at a time) so they could

>open them with notepad without them having to install file splitter and join

>them back together. Will this still work?

>

 

Use a program called HJsplit

It is free

[Guest HeyBub]

Re: Splitting .TXT files

 

GKW in GA wrote:

> I mentioned in my original post that it was too large for Excel so I

> was not considering Excel.

>

> I guess I could cut and paste but I was hoping to make them all about

> the same size. I was going to email the file to the requestor, so due

> to the limit on attachment size, if the original file was very large,

> I might have to create mutiple smaller files which could be time

> consuming to do manually. Therefore, I was hoping to automate it a

> bit.

>

>

 

ZIP the file. If the file's a text file, it'll end up about 10% of the

original.

[Guest metspitzer]

Re: Splitting .TXT files

 

On Thu, 10 Jul 2008 14:19:01 -0700, GKW in GA

<GKWinGA@discussions.microsoft.com> wrote:

>I mentioned in my original post that it was too large for Excel so I was not

>considering Excel.

>

>I guess I could cut and paste but I was hoping to make them all about the

>same size. I was going to email the file to the requestor, so due to the

>limit on attachment size, if the original file was very large, I might have

>to create mutiple smaller files which could be time consuming to do manually.

>Therefore, I was hoping to automate it a bit.

>

 

If the file size is the only factor you should use Winrar. It will

squish the file small enough to send in one whack.