M
mmccoog
Is there a way to split a .txt file into smaller files based on the number of
records?
records?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bob I
..txt files don't have records, only lines. You could copy the file and
delete sections. If you are referring to IMPORTING the txt file into
Excel there are macros to do that.
delete sections. If you are referring to IMPORTING the txt file into
Excel there are macros to do that.
M
mmccoog
Sorry, lines. I've seen one of the macros and it's pretty intense. I was
looking for an easy way to split the file before bringing it into excel.
looking for an easy way to split the file before bringing it into excel.
B
Bob I
Breaking in half=copy file to an A file and a B file then open and
delete second half of A save, open B and delete first half. Notepad will
show a line location of your cursor on the status bar at the bottom of
the window.
delete second half of A save, open B and delete first half. Notepad will
show a line location of your cursor on the status bar at the bottom of
the window.
M
mmccoog
Thanks Bob. Is there a way to automate that step?
B
Bob I
Well, then you are back to the programming thing again.