Shell Programming and Scripting

Hi,

Iam working on Sun solaris machine.I have a file with ids in the below format.

1
2
3
4
5

I want it as:
1,2,3,4,5

I use these commands individually to get into that format:

vi file
/1,$s/$/,/g
This adds commas in the file and then i save it.
next i use this command : cat file | tr '\n' ' '
which gets into the format as 1,2,3,4,5.

Now i want to write a script which does this work ie.read content from file add commas and then bring in the required format.Can someone help me out??

1 command:

Code:

perl -le 'print join ",", map { chomp; $_ } <>;' file

Thanks a lot.can u please tell me how will i redirect these ids into a file.
ie the output of this command perl -le 'print join ",", map { chomp; $_ } <>;' file into another file.

The same way you'd redirect the output of any other command:

Code:

 cmd > file

Ya I recalled that after i sent the post :$
Anyways Thanks!!!

---------- Post updated at 04:00 PM ---------- Previous update was at 03:42 PM ----------

Is there any way that mysql query reads the content from this file and selects matched data from another table.
ie I have a table named xyz which has same ids as in that file.
I want this query to get count of the ids from xyz file by matching the ids.

at mysql prompt i run this command which gets me the count from xyz table.
mysql>select count(*) from xyz where id in (1,2,3,4,5);
Now i want the sql query to read the file and match these ids with ids in xyz table and get me the count.

There is, but I'd recommend starting a new thread for this, as it's basically a new question.

Thanks and Ok.