I am trying to input a 40 million row text file, sort it and output to a new file. I have successfully written a macro to sort a file and save it to itself. I am using a bat file to run. Below is the code I have but I don't know how to get it to save to new file in order to preserve the original in case something happens.
InsertMode
ColumnModeOff
HexOff
UnixReOff
SortAsc 47 78 235 242 1 42 43 46
SaveAs "D:\HNDATA\CRMSdata\iservice50"
InsertMode
ColumnModeOff
HexOff
UnixReOff
SortAsc 47 78 235 242 1 42 43 46
SaveAs "D:\HNDATA\CRMSdata\iservice50"