DosTips.com

thank you.

i only added the semicolon to your code and it works

we have a multiple scripts (*.sql) that is spread out of multiple subfolders. i need to get all of those scripts in one script including the subfolder paths. i use this command: dir *.* /s /b /a-d > warren.sql this works fine it will list all the files including the subfolder path and puts it in one...

The variables you are using are coming from the Tidal. So in essence you are working within the confines of the Tidal Scheduling software. I don't think we have too many subject matter experts on that software around here. Cisco has a community forum that you can get help with for all their product...

actually it is the scheduling tool that execute the windows command. i supply the windows command to the scheduling tool and it will execute it.

yes and it will not work because if I removed the wildcard (asterisk) it will translate to
NY_20180110_08.xml

the file is in NY_20180110_082629.xml

i have these 2 files NY_20180110_082629.xml NY_20180110_082629_response.xml and i have a basic command like copy /y NY_<SysDate.yyyymmdd>_<SysTime.HH>*.xml e:\Apps that command is actual run from the tool called tidal software which is basically a job scheduling software. what happens is that both f...

if i want to run it from the command line without using a batch file how do i do it? so i can just use run the code from a job scheduler without having to call the batch file. thanks. i run the code in command line and i am getting this error: R:\temp>FOR %%I IN ("*.sql") DO (SET fn=%%~nI ...

thank you that works.

i have this small piece of code that is not working. basically i need to extract the filename without the extension and make it look like only the first 20 characters. e.g. sanbox_BULKLOAD_EXPORT.sql output: sanbox_BULKLOAD_EXPO this is because the application interface when i will move the file onl...