Search Results

it gets created from a stored proc .. gets saved in unix directory .xls.. which needs to ftp to winndows server

If you can just help me how to split a file irrespective of format... I think i can...

it saved with .xls as the extension
Basically i want to know howwe can split the file at every 65K records.. or just say if i have a file with 40 records i want to make it into 4 files with 10...

I have an excel file with more than 65K records... Since excel does not take more than 65K records i wan to split the file and send it as two excel files... Could some help me how to use the csplit...

HI ,

I need to get the timedifference between two values... which funcation will help

eg: difference betweem 19:22 and 19:43 should give 21 mins

We receive files daily and archive them in a directory... I want my script to check and delete all teh files that older than 3 months though my script... I have naming convention for the files... How...

Thank you it worked... but i have one more doubt

how can i set systemdate to Jan2006? once i set i can recvert it back right???

also now since its dec 2005 i am getting "200511" for previous...

Thank you but i don't want to use any script again...

My main aim is to get a string called "200511" into variable when the its dec 2005
and "200512" when its jan 2006 and '200601' when its feb...

Hi,

My task to to delete files which are of previous months.

I have files named as follows *CCYYMMDD.xls. on a particular day i have delete previous months files

i.e in Dec i have delete all...