Re: sqlplus and here document

From: Robert Klemme <bob.news_at_gmx.net>
Date: Mon, 27 Feb 2006 10:17:04 +0100
Message-ID: <46fucgFb24qaU1@individual.net>

Joel Garry wrote:
> Robert Klemme wrote:
>

>> 
>> Trailing white space in line 40?  To be on the safe side I'd not
>> reuse the same terminator sequnce, so better use EOF1 and EOF2.
>> 

>
> This sounded vaguely familiar, so in my directories with scripts I
>
> grep ^EOF *.ksh|grep -v F$
>
> and sure enough, found two scripts that have had this problem for
> years, that I never could quite see what the problem was. Sometimes 4
> eyes just aren't enough. :-)
>
> Thanks!

You're welcome! A nice way to visually check this is this:

sed -e 's#$#|#' your_file

You can also fix this with

sed -i.bak -e 's# \+$##' your_file
sed -i.bak -e 's#[[:blank:]]\+$##' your_file

(If your sed supports "-i").

Kind regards

    robert Received on Mon Feb 27 2006 - 03:17:04 CST