topic Deleting spaces at the end of line in a file in Operating System - HP-UX

Deleting spaces at the end of line in a file

Sammy_2 — Fri, 10 May 2002 18:49:01 GMT

How do you delete blank spaces from the end of each line in a file ? (using either a awk, sed, or just vi editor)

Re: Deleting spaces at the end of line in a file

Sanjay_6 — Fri, 10 May 2002 18:55:36 GMT

Hi Sam,

Try this link,

http://forums.itrc.hp.com/cm/QuestionAnswer/1,,0xed737d4cf554d611abdb0090277a778c,00.html

Hope this helps.

Regds

Re: Deleting spaces at the end of line in a file

S.K. Chan — Fri, 10 May 2002 18:57:13 GMT

This will delete trailing spaces and tabs from end of each line.

# cat file | sed 's/[ \t]*$//' > newfile

Re: Deleting spaces at the end of line in a file

A. Clay Stephenson — Fri, 10 May 2002 19:02:37 GMT

This would be one method:

cat myfile | perl -e 'while () { $_ =~ s/\s+/$//; print "$_\n"; }' > newfile

Re: Deleting spaces at the end of line in a file

John Payne_2 — Fri, 10 May 2002 19:09:27 GMT

If you want to do it manually, vi the file. Go to the line you want and to the end of the line where the spaces are, then hit the 'x' key until all the spaces are gone. Then go to the next line you want to edit and continue.

To get out of vi, ':wq!'. If you want to get out without saving, ':q!'.

Hope it helps

John

Re: Deleting spaces at the end of line in a file

Sachin Patel — Fri, 10 May 2002 19:10:14 GMT

Hi Sam you can use sed

# delete trailing whitespace (spaces, tabs) from end of each line
sed 's/[ \t]*$//' # see note on '\t' at end of file

# delete BOTH leading and trailing whitespace from each line
sed 's/^[ \t]*//;s/[ \t]*$//'

Sachin

Re: Deleting spaces at the end of line in a file

Sammy_2 — Fri, 10 May 2002 19:36:19 GMT

Thanks sanjay for the link.
Clay, glad you showed me a way in perl. Am learning perl and will try it.
Chan and Sachin, do appreciate it .
And John, thanks for the help but I am trying to do it globally.

Re: Deleting spaces at the end of line in a file

H.Merijn Brand (procura — Sat, 11 May 2002 06:37:13 GMT

Not for the points!

A.Clay, learn the command line switches:

cat myfile | perl -e 'while () { $_ =~ s/\s+/$//; print "$_\n"; }' > newfile

is equal to

perl -ple 's/\s+$//' newfile

easier to read, ain't it?

Re: Deleting spaces at the end of line in a file

H.Merijn Brand (procura — Sat, 11 May 2002 06:40:43 GMT

N/A

Hit submit toooo early

cat myfile | perl -e 'while () { $_ =~ s/\s+/$//; print "$_\n"; }' > newfile

s/\s+/$// is illegal syntax, you mean s/\s+$//

in substitutions without extra flags, the $ in perl will match *before* the newline, so above (and my previous post) will add newlines

perl -pe 's/\s+$//' outfile

should do. I now dropped the -l flag, which adds a newline to every print statement

Re: Deleting spaces at the end of line in a file

Graham Cameron_1 — Sat, 11 May 2002 07:43:12 GMT

This would seem to do it, with less hoeroglyphics than most so far...

cat myfile|sed "s/[[:space:]]*$//" > newfile

It also handles all whitespace characters.
BTW - is this an Oracle spool file? If so you can suppress the spaces using
"SET TRIMSPOOL ON".

Graham