creating a .csv file in bash
Posted on 2009-04-22
I have a bash script that ssh onto many machines and changes to the root user to collect information from the machine. I collect the same information from each machine and then output it to the same file for each host. The problem is the formatting though. I want to be able to save the output such that I can open the file in excel. I want the file to have the results of command 1 from each server in one column and all the results of command 2 in a column.
I tried to do a simple test on the command line settings IFS=';'' command 1; command2 but it prints the results of command 1 and command 2 on separate lines.
I hope you can help.