Hi ,
I have a text file look like the following:
'/ttt/aaa'
'/ttt/bbb'
'/ttt/ccc'
'/ttt/ddd'
'/ttt/eee'

1. I need to rebuild its content and make it look like :
'/ttt/aaa','/ttt/bbb','/ttt/ccc','/ttt/ddd','/ttt/eee'
2. I cant create a new file. the changes need to be done inside the same file
can one suggest how to do it ?

Thanks.

2. If you have no privileges to write files you can't do this anyway.
1.

Hi ,
I tried to to implement you suggestion, as follow:

ListOfFilesToImport="/${SOURCE_ORACLE_SID}/TTS/ListOfFilesToImport.lst"
tr -s '\n' ',' $ListOfFilesToImport $ListOfFilesToImport.tmp; mv $ListOfFilesToImport.tmp $ListOfFilesToImport

But got the follwoing error:
Usage: tr [ -c | -cds | -cs | -ds | -s ] [-A] String1 String2
tr [ -cd | -cs | -d | -s ] [-A] String1
mv: /tsdwh/TTS/ListOfFilesToImport.lst.tmp: cannot access: No such file or directory

Any Suggesion ?

add the < and > as Jim poosted, they were part of the code, not indicating the the filename should be adjusted.

< file is redirecting the contents of the named file to stdin of tr
> is redirecting stdout from tr to the second named file.

cat <oldfile> | tr -s "
" "," > <oldfile>

Hi All,

Jim suggetsion: tr -s '\n' ',' < oldfile > tmpfile is almost perfect.
Its add an extra ',' at the end of the file:
'/ttt/aaa','/ttt/bbb','/ttt/ccc','/ttt/ddd','/ttt/eee',
Any suggestion how to remove it ?

Thank You !!!

Here's another way to do it:

Without the pipe to sed, you'll get blank spaces in between values