Solved

setting variables for additional processing in batch script

Posted on 2014-02-22
9
231 Views
Last Modified: 2014-02-23
Hi EEE

I have a txt file with the following format:
ServerName\Dir1\file1.pdf newfile1_test.txt newfile1 n
ServerName\Dir2\file2.pdf bestfile2_test.txt bestfile2 b

etc

I want to write a batch script that does the following:

1. Read each line from the text file for a round of processing
   1.1 Store each of the four strings of the line into 4 vars  - source , destfile, destfolder, destpparentfolder
    1.2  Check if destparentfolder exists on the C:/ of server2.If it doesn't, create it.
        1.3 Check if destfolder exists under C:/destparentfolder. If it doesn't, create it.
          1.4 Put the destfile in the C:/destparentfolder/destfolder.
0
Comment
Question by:LuckyLucks
9 Comments
 

Author Comment

by:LuckyLucks
ID: 39879948
In our example above, ServerName\Dir1\file1.pdf will be stored under C:/n/newfile1 as newfile1_test.txt
0
 
LVL 28

Accepted Solution

by:
Bill Bach earned 475 total points
ID: 39880581
It is not clear it you want to write a batch script and you have a specific question, or if you want someone to write the entire batch script for you.  In any event, this script should do it:

FOR /F "tokens=* delims=" %%x in (input.txt) DO call :doit %%x
exit

:doit
if not exist C:\%4 MD C:\%4
if not exist C:\%4\%3 MD C:\%4\%3
copy %1 C:\%4\%3\%2


It will read the INPUT.TXT file and call DOIT for each line of the source file, which then do each of the three steps you asked for.
0
 
LVL 45

Expert Comment

by:aikimark
ID: 39880672
1. I think you might get a simpler solution using xcopy or robocopy, since they are capable of creating the destination paths they need.

2. I do not understand the control statements from your posted example and description.
0
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 

Author Comment

by:LuckyLucks
ID: 39880897
Bill, How do I get rid of the overwrite and the is the file a file or directory (when no overwrite)?
0
 
LVL 28

Expert Comment

by:Bill Bach
ID: 39880919
I figured that the batch file part was the hard part, and that you'd know how to use the COPY command.  The help screen for the COPY command comes in handy here:

 /Y           Suppresses prompting to confirm you want to overwrite an existing destination file.

The switch /Y may be preset in the COPYCMD environment variable. This may be overridden with /-Y on the command line.  Default is to prompt on overwrites unless COPY command is being executed from within a batch script.


So, add the "/Y" switch after "COPY" to avoid the prompt.  You can also use XCOPY, RoboCopy, or a host of other command-line copy tools.  See each tool's specific command line options for properly using it.
0
 
LVL 53

Assisted Solution

by:Bill Prew
Bill Prew earned 25 total points
ID: 39880987
Ne real need for a subroutine here, so just to show a slightly more compact approach:

@echo off

set ControlFile=c:\temp\control.txt

for /f "usebackq tokens=1-4" %%A in ("%ControlFile%") do (
  if not exist c:\%%D\ md c:\%%D
  if not exist c:\%%D\%%C\ md c:\%%D\%%C
  copy /Y %%A c:\%%D\%%C\%%B
)

Open in new window

~bp
0
 

Author Closing Comment

by:LuckyLucks
ID: 39881347
Thank you all.
0
 

Author Comment

by:LuckyLucks
ID: 39881360
With a /Y I still get - Does C:\a\abc\abcfile1.pdf specify a file name or directory name on the target <F=file, D=directory>?
0
 
LVL 28

Expert Comment

by:Bill Bach
ID: 39881434
Switch to XCOPY, and thay should go away.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction: Recently, I got a requirement to zip all files individually with batch file script in Windows OS. I don't know much about scripting, but I searched Google and found a lot of examples and websites to complete my task. Finally, I was ab…
User Beware!  This is a rather permanent solution to removing your email from an exchange server.  The only way to truly go back is to have your exchange administrator restore your mailbox from backups.  This is usually the option of last resort.  A…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question