Use MS-DOS For Loop to retrieve values from Excel fields

March 31, 2012 at 00:42:08
Specs: Windows XP
I have a rather challenging requirement at work and would be extremely grateful if someone could help with a solution. This then is the scenario:

As part of our Configuration and Release Management process, we currently record all files that are to be released or deployed in a spreadsheet. The spreadsheet is rather basic with 3 main columns of data covering the following:

Column 1 - The file name
Column 2 - The source location of the above file (TFS in our case)
Column 3 - The version number of the above file (Changeset number in the case of TFS)

What we therefore have is something that looks like the below representation, the vertical bar being the separator for each Excel row cell: | $/TFSServerName/ProjectA/SolutionA/SourceCode | 320012 (changeset no)

Can I stress though that each spreadsheet always contains multiple rows of similar entries as above, i.e. multiple files to be processed. The changeset numbers also tend to vary for each file.

What I am therefore looking to set up is an MS-DOS For Loop that will retrieve the three values from each row and parse them into another command (e.g. another For Loop) which performs some other task like a checkout of each file, using TFS command line syntax.

The main focus as far as this query goes is on the MS-DOS For Loop requirement and not the TFS command line script.

Anyone have some tips on how to achieve this please?

See More: Use MS-DOS For Loop to retrieve values from Excel fields

Report •

April 3, 2012 at 06:13:13
You'd have to save the spreadsheet as one of the plain text options for this to be viable. It'd probably be easier to use Excel to get your task done.

How To Ask Questions The Smart Way

Report •

April 4, 2012 at 14:42:59
This is addressed to IVO who sent me a private message on this thread.

Thanks for offering to assist with my problem, but I'm afraid I will flatly refuse your offer of assistance.

The primary purpose of these forums is to share knowledge and I can certainly confirm to have learned and likewise shared so much with other forum users, words cannot describe just how sites like this have dug millions of people out of a hole.

Which is why I am at a loss as to why you'd want to offer any assistance in private. Like I said, this is a public knowledge sharing forum, not one for shrouding knowledge in secrecy. If you're therefore not willing to share freely and openly, then this isn't the site for you.

This isn't a website running or endorsing scams and if that's what you're into, then please don't waste anyone's time here.

Thank you.

Report •

April 4, 2012 at 15:49:46
I should point out we've had at least one IVO impostor running around.

How To Ask Questions The Smart Way

Report •

Related Solutions

April 5, 2012 at 03:35:15
Here the private message I sent to Hitman as answer to what posted in post #2. Maybe time has gone to leave this Forum(s) (almost for me).

The primary reason why I offered my help via private messages is the proposed solution is quite complex to be posted directly on the Forum and better suited to mail attachment.

The second is the attention to leave open your thread to other guys/gals solutions since often a unanswered post looks more actractive than a hit one.

I am member since 2002 and use this way to contact other members when solutions require a tighter information exchange.

Sorry you interpreted my way as vicked plans.

Ivo Luigi Bertani (IVO)
Milano - Italy (EU)

Report •

Ask Question