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
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?
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!