hi Zaxxon,
that really worked very well.
But now a new issue like in my file i have the text like this
CREATE OR REPLACE FUNCTION "OWNER"."TABLE_SHIPMENT" RETURN VARCHAR2 IS
but when i use the query that you have provided if the text after tehd elimiter
dot has space in between the below error will occur.
mv: when moving multiple files, last argument must be a directory
Try `mv --help' for more information.
the code should be modified such that it doesnt care about the space and picks only the word
TABLE_SHIPMENT from the text.
we cant take by position also because each words before the text varies.
Kindly help me out.
thanks for ur valuable replies and for the future solution too
Arunmanas