Hi ,
I am FTPing the file. Once the file is FTPied I need to check whether that file currently transferred is of .xls and I need to convert the same to a flat file. What command to use to find the extension of the file?.

Thanks
Mahalakshmi.A

Hi Maha,

Prob this shud help u.

/scripts/scr-bk-04-dec:>var=temp.cts
/scripts/scr-bk-04-dec:>echo $var | cut -d "." -f2
cts
/scripts/scr-bk-04-dec:>

Thanks,
Sharif.S

Thanks sharif. Can u explain me about this cut command. What does f2 and d mean?.

echo a.b.xls | awk -F"." '{ print $NF }'

it will alway give you extension whether file name contain more than 1 dot (.)


------------------
Ajay

Cut :

Purpose : STrips/Cuts the required part from the passed input text
Usage:
cut -d "<value> -f <value> or -c <value>

-d = Delimiter
Seperator using wich u want divide ur text, Like "ABC,DEF" here , can be used as delimiter.

-f = field num

This is similar to column numbers. Inthe abv example ABC is field 1 and DEF is field# 2 if input is divided using comma.

-c = Character

cut -c 1,3

this will cut between 1st character to 3rd char.


Hope u understood wat i tried say.

Thanks,
Sharif.S

Using ksh built-in:

Thanks all of you for all your replies. It all worked fine and I am using the command which suits the requirement.

Regards
Mahalakshmi.A