How to input .txt file into .xls spreadsheet

wereyou · December 22, 2006, 2:13pm

I need to take the totals from my script and input them into a excel spreadsheet. Right now, I just copy and paste. Is there an easier way?

is the total jobs in ABEND state

is the total jobs in SUCC state

is the total jobs in HOLD state

vgersh99 · December 22, 2006, 2:33pm

yes, there is.
parse your file and create a CSV file.
post exactly what you have using vB-codes.