DosTips.com

I want to create a batch script to run a database procedure and give me the results in a flat file. I am using exadata. I want to run the batch from a remote windows server. 1. Below is the procedure sp_analyze_wt.sql CREATE OR REPLACE PROCEDURE x.sp_analyze_x AUTHID DEFINER AS BEGIN dbms_stats.gath...

Thank you!

Hi,

I have few files in a folder. Just want to rename all and add test at the end of the file. Can any one please see this?
existing file name xyz.txt, abc.txt
want to rename as xyz_test.txt, abc_test.txt

Thanks,

Thank you

Hi, For /f "tokens=2-4 delims=/ " %%a in ('date /t') do (set mydate=%%c%%a%%b) Here mydate gives 2018419 which is YYYYMMDD format. I want the date format in YYMMDD. Please see, if this is possible in the above code. I tried below and it works. Set mydate=%date:~-2%%date:~4,2%%date:~7,2% This gives t...

yeah, I see it now. quoted it and it is now resolved.

Thank you.

@echo on &setlocal setlocal enableDelayedExpansion If "%computername%" == "DTC" ( SET NS=\\xx SET OPSDIR=!NS!\ProAdmin SET COGDIR=!NS!\CREM ) set "list=%COGDIR%\Config\Copy_Daily_EMTS_Reporting.txt" echo %list% pause Why the list shows a space after cogdir in list? How to remove that space? it shows...

Thank you!

Hi,

Never mind pls. It worked.

Please ignore the query.

With this, computer name shows in upper case. Please see the attachment.

I want to run another batch file when executed on a particular computer. But below script is not working, please suggest.

Thank you a lot.

Hi, I have these files in a folder ab and I want to replace the spaces in the file name to _. XXXX_acc-er-in.pdf xxxx_can mess comp-en-us.pdf dddd_ee_le_ang-er-in.pdf cccc_Rel File ope-in-er.pdf xxx_etiti File ope-in-er.pdf So it would be XXXX_acc-er-in.pdf xxxx_can_mess_comp-en-us.pdf dddd_ee_le_an...

Another few queries on this code. Here while converting the pdf to txt, i am keeping the required pdfs in a separate folder temporarily "Today_Files" , converting the text to AllTextFiles and finally moving all the text to final folder. In the final folder, there would be the same files with differe...

Thank you. This is perfect.