parsing urls from windows batch file

Posted by modest on Stack Overflow See other posts from Stack Overflow or by modest
Published on 2012-09-07T21:35:51Z Indexed on 2012/09/07 21:37 UTC
Read the original article Hit count: 212

Filed under:

vbscript

|

batch-file

I have a text file (myurls.txt) whose contents are a list of URLs as follow:

Slides_1:   http://linux.koolsolutions.com/svn/ProjectA/tags/REL-1.0
Exercise_1: http://linux.koolsolutions.com/svn/ProjectA/tags/REL-1.0

Slides_2:   http://linux.koolsolutions.com/svn/oldproject/ProjectB/tags/REL-2.0
Exercise_2: http://linux.koolsolutions.com/svn/ProjectB/tags/REL-1.0

Exercise_3: http://linux.koolsolutions.com/svn/BlueBook/ProjectA/tags/REL-1.0

Now I want to parse this text file in a for loop such that after each iteration (for e.g. take the first url from the above file) I have the following information into different variables:

%i% = REL-1.0
%j% = http://linux.koolsolutions.com/svn/ProjectA
%k% = http://linux.koolsolutions.com/svn/ProjectA/tags/REL-1.0

After some experiment I have the following code but it only works (kind of) if the URLs have same number of slashes:

@echo off
set FILE=myurls.txt
FOR /F "tokens=2-9 delims=/ " %%i in (%FILE%) do (
@REM <do something with variables i, j and k.>
)

I am fine with other solutions like for e.g. using Windows Script Host/VBS script as long as it can run with a default Windows XP/7 installation. In other words, I know I can use awk, grep, sed, python, etc. for Windows and get the job done but I don't want the users to have to install anything besides a standard windows installation.

© Stack Overflow or respective owner

Related posts about vbscript

Associate mount points with local disks in VBscript / WMI

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a VBscript that outputs various config items about a system. Both hardware and software. I can output disks and their associated partitions. I can output mount points. I do not seem to be able to associate a mount point with a local disk (where it actually is a local disk). I need to be able… >>> More
Any other preprocessor directives in VBScript/Classic ASP?

as seen on Stack Overflow - Search for 'Stack Overflow'
The only pre-process directive that I know about in VBScript / Classic ASP is the #include. I don't know if that is the official name but I'm basically looking for code that can execute code or other instructions before the general VBScript. Are there any other such directives in VBScript? Such as… >>> More
how to pass and access command line arguments in VBscript

as seen on Stack Overflow - Search for 'Stack Overflow'
how to pass and access command line arguments in VBscript >>> More
[OT] : Windows Activation, en masse

as seen on SQL Blog - Search for 'SQL Blog'
This weekend I discovered a minor issue in one of my virtual environments. I had built out 100 VMs based on a Hyper-V template, but I forgot to activate the original source before creating the template, so all of the machines were suddenly out of compliance. While easy enough on a one- or two-machine… >>> More
Retrieve user details from Active Directory using SID

as seen on Server Fault - Search for 'Server Fault'
Hi, How can I find a user in my AD when I have his/her SID. I don't want to rely on other attributes, since I am trying to detect changes to these. Example: I get a message about a change to user record containing: Message: User Account Changed: Target Account Name: test12 Target… >>> More

Related posts about batch-file

Execute batch file after another batch file completes

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a batch file coordinating the activity of two other batch file. How can I make it execute the second batch file only after the first bat file finishes execution. I do not care if the first batch file executes successfully or not. >>> More
Running Java from a Windows batch file causes the batch file to stop

as seen on Super User - Search for 'Super User'
When I run Java from a Windows .cmd file (Vista 32-bit here), the Java command causes the batch file to stop executing additional commands. For example, this is a simple test.cmd file: java java This should cause Java to print its help message twice. However when I run it in cmd.exe, I get this: C:\>test C:\>java Usage:… >>> More
How to get around batch file processing limit

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a Windows batch file that processes all the files in a given directory. I have 206,783 files I need to process: for %%f in (*.xml) do call :PROCESS %%f goto :STOP :PROCESS :: do something with the file program.exe %1 > %1.new set /a COUNTER=%COUNTER%+1 goto :EOF :STOP @echo %COUNTER%… >>> More
Download a File in a Batch File

as seen on Super User - Search for 'Super User'
I've never done any scripting on Windows but now I need to write a batch file that downloads a file off the internet (amongst other things). If it was linux I would use wget. Is there a builtin executable that will download a file to a given directory? This needs to run on XP. >>> More
Batch file to java test

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a very simple question and I've even searched here but it's for a much simpler case than what I found examples of. I have a java program which has a simple System.in on the main function....I simply want to make a bat file which will run the java program and then enter the input stream automatically… >>> More