UNIX Desktop Questions & Answers

I would like to copy 2 parts of a csv file from Unix to an XL sheet. However to save time I do not want to format the column ever time I cut and paste into XL(Text2Column). I've used awk -F, '{Print $1, $2....}'. Is there a script or code that can automatically format the csv for XL columns?

Sample CSV
00:10,2344,2332,0,1,0,2,0
00:15,2311,2002,0,0,0,1,0
Sample XL
00:10|2344|2332|0|1|0,2|0
---------------------------
00:15|2311|2002|0|0|0|1|0

Thank you Ygor, I will give it a go and report back any issues.

I've used the script below

A.
BEGIN { FS = ","
RS = "\n"
OFS="\t"
}
{
print $1, $2, $3, $4, $5
}

Followed by

B.
awk -f abc < report.csv > report.xls

This generates the report I'm looking for, excellent!!!

However I now have some other questions

1. I would like the B. script above to find the csv file for the current day and convert that into the Excel format. The CSV file usual ends with a date format like: f_Jul30.csv.
How would I do this?

2. I would like to automatically insert a column into the excel sheet that would perfmon a1/(b1-k1) and result in a percentage value. Reason I cant do it from the original is because it's run from root.

3.How would I tranfer it from Linux to Windows?

Thanks!