0

I am compiling 77 individual files into one in Notepad ++. Each is roughly between 31,000 and 33,600 rows apiece. I have researched and found nothing on their being a hard cap on number of rows. I am at item 36 and when I copy its contents in Notepad ++, the pasted result is one long string or single row. Any ideas as to why this would work for the first 35 files and start messing up at 36?

Additional Info: When I paste the 36th text file to the bottom, it puts an E in the top row and then the one long string below that.

Sample. THe third row should be two rows starting with the field 32.

32   07  000000   2008
32   07  000001   2008
**32   08  000000   2009  32  08   000001   2009**
8
  • 1
    "I am compiling 77 individual files into one in Notepad ++" what does that mean? Commented Sep 29, 2017 at 22:26
  • Does the first number always be 32? If yes, then you can use regex replace to replace '32' with '\n32' Commented Sep 29, 2017 at 22:27
  • I have 77 individual text files that need to be consolidated into one. Every quarter we produce one of these text files but they are independent of each other. Commented Sep 29, 2017 at 22:29
  • @HarishTalanki, I am not sure that I understand. I am not finding and replacing but rather taking from one text file to another. Commented Sep 29, 2017 at 22:32
  • @TimWilcox you mean concatenating? Commented Sep 29, 2017 at 22:44

2 Answers 2

2

Do this in an automated way! For example, if you're using windows and have 77 files that end with a .txt extension, open a CMD prompt, usecd to go to the directory that contains the files, then type the following:

type *.txt >> new.txt

If you want to run this a 2nd time, first delete the generated file called 'new.txt'.

Sign up to request clarification or add additional context in comments.

2 Comments

OK, trying it now.
I have a command prompt open and it says "C:\Users\Name> From here do I type in where it is. For example, would it look like this? c:\users\name>my documents\file name
0

I was not able to figure out the command prompt item below. I resolved it, so to speak, by simply putting the 77 text files into 3. Apparently, there is a setting or an issue on my machine that caps it at about 1.49 million rows.

Comments

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.