Recent content by annanathan

Maybe I haven't explained the problem clearly... I have created a linear chart in Excel. I would like to retrieve the column id (eg. A, B, ... ) that the chart is reffering to using VBA. I need this id so that I could use it later in my VBA coding for other puposes. How do I do this? Please...

Hi All, I'm trying to retrieve the series from an already configured chart. I need to know what column is it referring to on the chart. Any help is appreciated, Thank you in advance.

Thank you very much... This is exactly what I was looking for... Regards, Jeya

HI Ed, The $1 gives me the full path with the name of the file found: eg d:/something/name_of_file.txt I just need 'name_of_file' to show... eliminating the path and the extension. Thank you in advance. Jey

Hi all, I need help to understand how to use the find command to get the name of the file only. find d:/something/ -name "*.txt" -exec another_script.sh {} \ ; I need to pass only the name of the file found in the 'another_script.sh'. (extenstion excluded also) Thank you in...

Thank you all... This is exactly what I wanted.

Hi all, I'm trying to create a directory with the current day of the following format: "date '%d_%B_%y'", since I want this job to run every day and create directory for each day... Then I want to change directory of the newly created directory, but it's not working. This is what I...

Thank you... it's working fine Where can I find all the built-in functions (like REPLACE) in Oracle?

I'm using Oracle... Thank you.

Thank you all for your help... I have used the substr as you have taught me and it's working like a charm. However I have another question Does anyone know how to find a particular character in a field (let's say a space) and substitute that with another character(let's say with nothing)...

Thank you guys... it works with substr... What about 5 characters from the right? and What about exactly the 5th character? Thank you in advance.

Hi All, Does anyone how to find the left 5 characters of a field in SQL? is there a built-in function that can be used to achieve this? Any help is appreciated. Thank you in advance.

Thank you.... Everyone has been of real help, especially gillou and mrjazz. I got my script to work thanks to you.

I'm very new to unix scripting, so I might sound dum, but I have another question: what does sed 's/://g' do? i tried the man page, but it doesn't help me much... Thank you.

Thank you all for you help... but I have one more question... The above examples remove the files of the day stamp of 08:30 exact of yesterday's files, right! What if I want to remove all files prior to that time stamp? let's say remove all the files in a particular directory prior to...