UNIX for Dummies Questions & Answers

Hi,
i have shell script which compiles n number of test cases and execute them one by one. i want to create report in excel through script in which two columns namely "test id" and "release".second column have two subcolumns namely compiles and excutes. so i want first column should display test id and in next two sub columns it should display YES or NO depending on the result of compilation and execution(PASSED or FAILED).

currently i am generating one text file from script only which shows test id and result of test cases.

i have attached both files current test result required excel format.

Please help me in this. Thanks!!!

we can make excel format simple like just making 4 columns..

"test id" "Release" "Compile" "Execute"
B_001.config FR1.1 Yes PASSED


so here first n last column we can take from text file that i have already created. second and third columns vales are same for all rows.

now anybody can suggest how to do this.

Your scriptfile has info about one single action only; it is not clear to which this is related, compilation or execution. And, in a .csv file you can't have subcolumns, so it will be three columns in total, once the action can be identified.

in my script three variables can give us input for each column...
1st column) "$i" which is test case name with id...
2nd column) "FRRELEASE" which is user input from command prompt
3nd column) "errstat" which can give compile status i.e. $?
4th columns) "RESULT" which gives execution result i.e. $PIPESTATUS[0]

so we have to create four columns as i have mentioned in second post. then wee need to pass all above listed values in each row.

no need to take input from text file.

hope you will get my purpose.

Assuming there are no spaces in the values itself

Code:

while IFS=' ' read testid release compile execute;do echo "$testid ; $release ; $compile ; $execute";done<testfile

(this is my first IFS attempt)

Hope this helps

hi,
testfile doesnot conatin any name like testid release compile execute.
i want these should be columns name in .csv file . after reading txtfile row by row it shouls print those vanlues in columns.

it will work??

If you dont understand the code submitted to you, you should not post here, this is for solving and helping people with the shellscript they submitted... moving to dummies...