How can I clear file form empty signs (spaces) and separate entries by comma "," ?

This is eg. file I got:

what I need to have:

use the tr command

Hi,

tr ' ' '.' < yourfile if only one space between characters.

If you have more than one space or 'spaces' is a tab then do a man tr on your linux to find the code for tab (I think it's \t).

Kind regards,

Eric

sorry for not explaining with detail but i was busy at the moment, you can solve this with a single command like this:

1) if your text file has numbers separated by several spaces

"new.txt"
123 456 789

the first thing to do is make them be separated by one space like this:

cat new.txt | tr -s ' '

that command line sends the contents of the file new.txt into the command tr (piping) and tells tr to squeeze the spaces together. now you either redirect the output to a temporary file or you can redirect it to tr again like this:

cat new.txt | tr -s ' ' | tr ' ' ','

the second pipe sends the output of the squeezed together numbers and tells tr to change all the single spaces to commas.

i hope that helps

enrique

show some of your code next time. you have been here from 2004, so i expect you to know how to do it by now.

ghostdog74, how do you post code?

By embedding the text between CODE tags. In advanced mode, just select the text and click on #. In the quick reply box, you have to write them as the following:

[CODE]This is a line of code[/CODE]

thanks

kike_coello: many thanks - works excellent
ghostdog74: what code are you talking about ? I got only plain text file

colucix - nice sed but it wont work under Solaris. I will check it later under Linux (ghostdog74 - same about ur solution)

Thanks.

use nawk on solaris.

I am talking about your effort! what did you try before you post in this forum.