UNIX for Dummies Questions & Answers

I've looked at a few different posts and none have entirely answered my question.

Wondering how i'd go about using AWK to export to an excel file, which i gather would be a .csv file from what I've read.

Atm my AWK command will read 2 files and export 2 files. Each of those files have 2 columns delimited by a space.

Ideally I want to have these 2 files to output to the one excel file in different columns for ease of comparing.

I can't begin to think about how to do this right now, my brains fried, any suggestions would be great.

I can supply sample code and data if this would help.

please provide the sample input file and the expected output

excel can also open csv file, can't it?
please give inputs and your expected output examples.

Sorry I was busy all weekend.

I'm using this to basically run daily checks on our linux box at work.

The initial query is..

Code:

find . -daystart -mtime 0 -type f | xargs ls -sSh > data_DDMMYY

I run a sed statement to remove leading zero's

Code:

sed 's/^ *//' data_DDMMYY > data_DDMMYY_1

And then finally this awk statement to compare yesterdays file to todays one.

Code:

awk '{if(FNR==NR) {arr[$0]++;next} if($0 in arr) { arr[$0]--; if (arr[$0] == 0) delete arr[$0];next}{print $0 >"FYes"}} END {for(i in arr){print i >"FTod"}}' yesterday_DDMMYY today_DDMMYY

In the below image you'll see I made an error and called a filename that didn't exist, doesn't make any difference just thought I'd point that out.