Shell Programming and Scripting

Hi All;

I try to create a excel like table with headers and some fields containing values, other long and complex mathematic formulas.

I have some header like : Name Formula Value True/False

Under name column, they are some formula names, formula column some long mathematic formulas like:

Daily something somehting Percentage ≡ Total number of something - ∑4i=1(Total number of someother thingsi - total number of a different thingsi) .


And value field is a numeric field containing 2 long numbers (10 digit or so). I want to write them as 2 different lines in same field. (value field)

True/false column consists of value t/f. So this will be filled manually so should be null.


So what is the easiest way to write them as an excel like table? I tried some printf command but they are all exploded. Is there an easier way to do it?

Thanks

Show the input you have and the output you want.

This is the table I would like to create. All the fields are same except I will fill vaule field with some number I obtained (they are stored in variables). They are numbers like 1204000000 (10 or 11 digits) and I want to write 2 numbers in value field for comparison maybe as 2 different lines in value fields.

Great, that's the output you want.

Now, show the input you have.

String fields are the inputs. They won't change. Value fields are the numbers.

And what do these string fields look like?

Exactly as above. I Will take these names and formulas in the table above and assign them to some string variable such as name1 name2...name8 etc formula1 formula2...formula8
formula3 and values to value1 value1 .... value8