5

Formatting Shell script output to Excel

view full story
linux-howto

http://www.unix.com – I am facing a problem formatting the output of my shell script in excel. We are directing the output of the script to an excel sheet and need long integer type data printed in Excel as it is (i.e. not in the default scientific notation). Also, leading zeroes(if any) in the output are getting truncated in the excel file. For example: Output of the shell script: 012310004594882 Current output from Excel: 1.231E+13 Desired output in Excel sheet: 012310004594882 Could someone help me with this. I am using ksh. (HowTos)