UNIX for Dummies Questions & Answers

Code:

oldname="dashboard.dat"
bash-2.05$ newname=${oldname%%.txt}".xls"
bash-2.05$ mv $oldname $newname

Hi Mani,

Jst try the below command.

sed "s/,/`echo "\t"`/g" t.dat > h.xls

Thanks

The easiest way is to replace all commas with a TAB. It will only convert to 1 column because you don't have any TAB to serve as the delimiter.

Of course, if you choose not the save it as a .xls format you can still open it in excel and have excel do the work. Whenever excel opens a text file a wizard pops-up asking you stuff on how to read/delimit the file. It can be by using a delimiter or a fixed width. But then that wouldn't be automated enough now.

So I suggest, replace all commas first with a TAB (maybe using sed - https://www.unix.com/cfmgoogle.php?cx...sa=Search#1157) then save a copy with a .xls extension, let excel do the work, sit down and just relax.

Thanks to both of u
its working
thanks...

I work with Unix data under Excel as well. What I did was save the data as a txt file, and import the txt file into Excel and set it so that any space or punctuation will separate the data into their individual grid. I saved the steps into a macro. All I have to do from then on is pressing a hotkey bound to that macro.