How to read from txt file and write it to xls?

Shell Programming and Scripting
1

Hello All,

I just want help in coding a simple shell script since i am a newbie for UNIX and i started learning unix and shell scripting basics recently.

I am having a data like this in .txt file.

Product Name : XYZ
Price : 678.1
Best Buy Price : 600

Product Name : ABC
Price : 465
Best Buy Price : 450

and so on..

Now i want to read these datas from the text file and write into a excel file in seperate columns such as

PRODUCT NAME PRICE BEST PRICE
XYZ 678.1 600
ABC 465 450

I hope i will get help with this..
thanks in advance..

2

The easiest way is:

Import into a spreadsheet which supports text iport (all of them?) and support export of .xls files (most of them) and export it as a .xls file.

Did you really want a more difficult way?

3

I really need to learn scripting.. Please post the code..

4

Do not post classroom or homework problems in the main forums. Homework and coursework questions can only be posted in this forum under special homework rules.

Please review the rules, which you agreed to when you registered, if you have not already done so.

More-than-likely, posting homework in the main forums has resulting in a forum infraction. If you did not post homework, please explain the company you work for and the nature of the problem you are working on.

If you did post homework in the main forums, please review the guidelines for posting homework and repost.

Thank You.

The UNIX and Linux Forums.