1

I currently am working on a file that is 3,430,900 characters long all in one string. I need to break/split this text string into 550 character segments so there is one 550 segment per line. Each segment is fairly standard but unfortunately there isn't a unique character or sequence that I could use "find and replace" to add a carriage return or line break.

This is a follow up to a question I asked a few days ago, which I did get a great answer to. But now I'm am running into Excel's 32,767 characters per cell limitations. I'm thinking that I may need to use something other than Excel. I have notepad++ and Ultra Edit but not sure if they are able to preform this action.

I can use the below formula with files smaller than 32,767 characters

=MID(Sheet1!$A$1,(ROW(1:1)-1)*550+1,550)

but anything bigger and excel automatically splits the file after the 32,767th character.

Ideally i would like to get a .txt file that has one 550 character record per line that i can bring into Excel for further processing.

Any help would be greatly appreciated!

R.J. Dunnill
  • 2,049
  • 3
  • 10
  • 21
kirk
  • 27
  • 4

1 Answers1

1

You may try the following find and replace in Notepad++, in regex mode:

Find:    .{550}
Replace: $0\r\n

This will find each 550 characters and replace with the same 550 characters followed by a newline (I used Windows newline \r\n, but if you are on Linux you may just use \n).

Tim Biegeleisen
  • 502,043
  • 27
  • 286
  • 360
  • Thanks Tim, This worked perfect in notepad++! I really appreciate the help, you made my day! – kirk Jul 18 '19 at 18:17