Hi,

I have a file like this

(ADD_MONTHS((Substr(Trim(BOTH FROM Translate(Maximum(closeDa
------------------------------------------------------------
2007-06-30 00:00:00

I have a requirement where i need just the date.

When i do: tail -1 filename|tr -s ""
my problem doesnot solve.I am getting leading spaces before the date.

I need an output like: 2007-06-30 00:00:00

Can anybody help me??

-- Mahek

To remove leading spaces, use

tail -1 filename | sed -e "s/^ \{1,\}//"

or to removed trailing spaces

tail -1 filename | sed -e "s/ \{1,\}$//"

you can try these as well

leading spaces :

tail -1 file1| sed -e "s/^ *//"

trailing spaces :

tail -1 file1| sed -e "s/ *$//"