I don't think the procedure is exceptionally long, or that 1 long procedure is any harder to optimize than the same code broken down into N smaller procedures to be...

Just pull it all in to a table as one field defined Varchar(MaxLen)

Then run a query against that table to parse it into the fields you want.

SQL is much quicker to process...