Combining the contents of two files

Shell Programming and Scripting
1

Hi,
I have a file a.csv on a Solaris 10 with the following content

you,me,them,us
us,them,you,me
them,you,me

and i have a second file b.csv with only a date and time stamp as

2013-08-14 00:00:00

I am trying to combining the two files in this way

2013-08-14 00:00:00,you,me,them,us
2013-08-14 00:00:00,us,them,you,me
2013-08-14 00:00:00,them,you,us,me

I tried to use the command paste -d, b.csv a.csv
but i get the result

2013-08-14 00:00:00,you,me,them,us
,us,them,you,me
,them,you,us,me

I would really appreciate if you can kindly help me out either using sed or paste.

Thanks

2

If your b.csv has ONLY one line, then this will do it:

 
$ cat a.csv
you,me,them,us
us,them,you,me
them,you,me
$ cat b.csv
2013-08-14 00:00:00
$ awk 'NR==1{the_date=$0} NR>1{print the_date","$0}' b.csv a.csv 
2013-08-14 00:00:00,you,me,them,us
2013-08-14 00:00:00,us,them,you,me
2013-08-14 00:00:00,them,you,me

Otherwise you would need to come up with the rule of which line from b.csv should be paired up with which line in a.csv

I see you would prefer to use sed or paste, but in your case you could use just shell

 
$ b=$( cat b.csv )
$ while read a; do echo $b","$a; done < a.csv  
2013-08-14 00:00:00,you,me,them,us
2013-08-14 00:00:00,us,them,you,me
2013-08-14 00:00:00,them,you,me

Again, that is only if b.csv has one line.

3

Migurus,

This worked and i really appreciate your time !!!

Thanks

4 
awk '{print v","$0}' v="$(cat b.csv)" a.csv
2013-08-14 00:00:00,you,me,them,us
2013-08-14 00:00:00,us,them,you,me
2013-08-14 00:00:00,them,you,me