Search found 9 matches

by warrentolentino
20 Nov 2018 11:22
Forum: DOS Batch Forum
Topic: How To Concatenate a String/Character
Replies: 3
Views: 342

Re: How To Concatenate a String/Character

thank you.

i only added the semicolon to your code and it works

Code: Select all

(for /f "delims=" %i in ('dir *.* /s /b /a-d') do @echo %I;) > "warren.sql"
by warrentolentino
20 Nov 2018 08:19
Forum: DOS Batch Forum
Topic: How To Concatenate a String/Character
Replies: 3
Views: 342

How To Concatenate a String/Character

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...
by warrentolentino
11 Jan 2018 11:02
Forum: DOS Batch Forum
Topic: copy with regular expression how to
Replies: 8
Views: 2305

Re: copy with regular expression how to

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...
by warrentolentino
11 Jan 2018 10:46
Forum: DOS Batch Forum
Topic: copy with regular expression how to
Replies: 8
Views: 2305

Re: copy with regular expression how to

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.
by warrentolentino
11 Jan 2018 09:59
Forum: DOS Batch Forum
Topic: copy with regular expression how to
Replies: 8
Views: 2305

Re: copy with regular expression how to

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
by warrentolentino
11 Jan 2018 08:52
Forum: DOS Batch Forum
Topic: copy with regular expression how to
Replies: 8
Views: 2305

copy with regular expression how to

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...
by warrentolentino
02 Oct 2014 12:37
Forum: DOS Batch Forum
Topic: for loop to get substring of filename
Replies: 5
Views: 2439

Re: for loop to get substring of filename

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 ...
by warrentolentino
02 Oct 2014 12:08
Forum: DOS Batch Forum
Topic: for loop to get substring of filename
Replies: 5
Views: 2439

for loop to get substring of filename

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...