Styjun

Lay out the Carpet

How does the UK government determine the size of a mandate?

What is the opposite of 'gravitas'?

Is expanding the research of a group into machine learning as a PhD student risky?

What is the best translation for "slot" in the context of multiplayer video games?

Avoiding estate tax by giving multiple gifts

Why didn't Theresa May consult with Parliament before negotiating a deal with the EU?

What happens if you roll doubles 3 times then land on "Go to jail?"

Escape a backup date in a file name

Term for the "extreme-extension" version of a straw man fallacy?

How do scammers retract money, while you can’t?

Where does the Z80 processor start executing from?

Sequence of Tenses: Translating the subjunctive

Is the destination of a commercial flight important for the pilot?

How does Loki do this?

Is there a problem with hiding "forgot password" until it's needed?

How did Arya survive the stabbing?

How does buying out courses with grant money work?

Did Dumbledore lie to Harry about how long he had James Potter's invisibility cloak when he was examining it? If so, why?

Different result between scanning in Epson's "color negative film" mode and scanning in positive -> invert curve in post?

India just shot down a satellite from the ground. At what altitude range is the resulting debris field?

What is paid subscription needed for in Mortal Kombat 11?

How to check is there any negative term in a large list?

What does 算不上 mean in 算不上太美好的日子?

Batch job to check filenames and archive

Batch script with for loop and pipeHow can I pass arguments to a batch file?Split long commands in multiple lines through Windows batch fileWindows batch files: .bat vs .cmd?How to sleep for 5 seconds in a batch file/cmd?How to “comment-out” (add comment) in a batch/cmd?The filename directory name or volume label syntax is incorrectBatch file that moves files when string is not in filename or when a file has finish writingUNC Paths Not Supported in called batch fileHow to rename or create a zip file with the name of its content using a batch fileChecking for naming convention in file?

0

I have a directory where users are saving their excel files that should adhere to a specific naming convention:

XX-TestFile.xlsx

where XX is a variable digit and -TestFile.xlsx should always be the same and not change. I'd like to be able to check through a batch job if files in the directory adhere to this naming convention.

If filename is misspelled, i.e. XX-TetsFiel.xlsx, XX is not a digit like 02 or even XX-testfile.xlsx (all lowercase), then files should move to an Error directory.

I am using below to move the files to achieve this. I am testing with 11-testFiel.xlsx but when I execute the .bat nothing happens - I get no errors and the file remains where it was before:

@echo off

for /f "delims=" %%a in ('dir /b *.xlsx | findstr /v "[0-9][0-9]-TestFile.xlsx"') do move "%%a" "C:TempArchiveError"

Many thanks in advance for your help!

batch-file for-loop io-redirection

share|improve this question

edited Mar 21 at 19:17

aschipfl

19.2k92958

asked Mar 21 at 15:56

Aligator3000Aligator3000

109215

• 
  
  
  

  
  4
  

  
  
  
  
  
  

  
  
  The pipe symbol | has to be escaped with a caret ^| inside a for /f command. If you'd executed the batch in an open cmd window you would see the error message.
  
  – LotPings
  Mar 21 at 16:23
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @LotPings: Thanks, that worked!
  
  – Aligator3000
  Mar 21 at 16:31
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  You need to escape | with the batch file escape character, the caret (^), so it will become ^|. This happens because | is executed in higher prio than the for loop.
  
  – double-beep
  Mar 21 at 16:34
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @double-beep.. but LotPings already said that... why not just upvote his comment instead of repeating it?
  
  – Gerhard Barnard
  Mar 21 at 17:18
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @GerhardBarnard sorry, this is not a place to discuss that, but as you can see, I have added some explanations.
  
  – double-beep
  Mar 21 at 18:28
  

  
  
  
  

 | 
show 2 more comments

0

I have a directory where users are saving their excel files that should adhere to a specific naming convention:

XX-TestFile.xlsx

where XX is a variable digit and -TestFile.xlsx should always be the same and not change. I'd like to be able to check through a batch job if files in the directory adhere to this naming convention.

If filename is misspelled, i.e. XX-TetsFiel.xlsx, XX is not a digit like 02 or even XX-testfile.xlsx (all lowercase), then files should move to an Error directory.

I am using below to move the files to achieve this. I am testing with 11-testFiel.xlsx but when I execute the .bat nothing happens - I get no errors and the file remains where it was before:

@echo off

for /f "delims=" %%a in ('dir /b *.xlsx | findstr /v "[0-9][0-9]-TestFile.xlsx"') do move "%%a" "C:TempArchiveError"

Many thanks in advance for your help!

batch-file for-loop io-redirection

share|improve this question

edited Mar 21 at 19:17

aschipfl

19.2k92958

asked Mar 21 at 15:56

Aligator3000Aligator3000

109215

• 
  
  
  

  
  4
  

  
  
  
  
  
  

  
  
  The pipe symbol | has to be escaped with a caret ^| inside a for /f command. If you'd executed the batch in an open cmd window you would see the error message.
  
  – LotPings
  Mar 21 at 16:23
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @LotPings: Thanks, that worked!
  
  – Aligator3000
  Mar 21 at 16:31
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  You need to escape | with the batch file escape character, the caret (^), so it will become ^|. This happens because | is executed in higher prio than the for loop.
  
  – double-beep
  Mar 21 at 16:34
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @double-beep.. but LotPings already said that... why not just upvote his comment instead of repeating it?
  
  – Gerhard Barnard
  Mar 21 at 17:18
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @GerhardBarnard sorry, this is not a place to discuss that, but as you can see, I have added some explanations.
  
  – double-beep
  Mar 21 at 18:28
  

  
  
  
  

 | 
show 2 more comments

I have a directory where users are saving their excel files that should adhere to a specific naming convention:

XX-TestFile.xlsx

where XX is a variable digit and -TestFile.xlsx should always be the same and not change. I'd like to be able to check through a batch job if files in the directory adhere to this naming convention.

If filename is misspelled, i.e. XX-TetsFiel.xlsx, XX is not a digit like 02 or even XX-testfile.xlsx (all lowercase), then files should move to an Error directory.

I am using below to move the files to achieve this. I am testing with 11-testFiel.xlsx but when I execute the .bat nothing happens - I get no errors and the file remains where it was before:

@echo off

for /f "delims=" %%a in ('dir /b *.xlsx | findstr /v "[0-9][0-9]-TestFile.xlsx"') do move "%%a" "C:TempArchiveError"

Many thanks in advance for your help!

batch-file for-loop io-redirection

share|improve this question

edited Mar 21 at 19:17

aschipfl

19.2k92958

asked Mar 21 at 15:56

Aligator3000Aligator3000

109215

XX-TestFile.xlsx

@echo off

for /f "delims=" %%a in ('dir /b *.xlsx | findstr /v "[0-9][0-9]-TestFile.xlsx"') do move "%%a" "C:TempArchiveError"

share|improve this question

edited Mar 21 at 19:17

aschipfl

19.2k92958

asked Mar 21 at 15:56

Aligator3000Aligator3000

109215

share|improve this question

edited Mar 21 at 19:17

aschipfl

19.2k92958

asked Mar 21 at 15:56

Aligator3000Aligator3000

109215

edited Mar 21 at 19:17

aschipfl

19.2k92958

edited Mar 21 at 19:17

aschipfl

19.2k92958

asked Mar 21 at 15:56

Aligator3000Aligator3000

109215

asked Mar 21 at 15:56

Aligator3000Aligator3000

109215