Petri IT Knowledgebase Forums - DOS Command Shell http://www.petri.co.il/forums/ For good old command line and batch file issues. en Sat, 18 May 2013 17:28:54 GMT vBulletin 60 http://www.petri.co.il/forums/images/steelblue/misc/rss.jpg Petri IT Knowledgebase Forums - DOS Command Shell http://www.petri.co.il/forums/ Read, parse, then write to a file http://www.petri.co.il/forums/showthread.php?t=63239&goto=newpost Thu, 18 Apr 2013 17:55:27 GMT I have to need to read in a filename from each sub folder, find a string I am looking for, then write to a text file. The filename from each sub folder is always the same.

I use "find" to look for the string. This is what I have...

Code:
@ECHO OFF

       
SET filename=metadata.txt

FOR /F %%D in ('dir /b /a:D') DO (

(find /i "<artist_name>" "%%D\%filename%")
(find /i "<title>" "%%D\%filename%")
(find /i "<track_number>" "%%D\%filename%")

)
How do I assign variables for "artist_name", "title", and "track_number", then echo/print each variable to a file so that the result looks like

artist_name, title, track_number (comma delimited, for example)

Thanks in advance! ]]> DOS Command Shell graffixx http://www.petri.co.il/forums/showthread.php?t=63239 DOS Batch file to pull certain info from a text file http://www.petri.co.il/forums/showthread.php?t=63091&goto=newpost Thu, 04 Apr 2013 19:33:08 GMT Guys,

I'm having trouble getting a dos batch file to work correctly to pull only certain lines from a text document. I need it to read through a .txt file and copy the lines that have an O (oh) in the 14th field and a three character value in the 19th comma delimited field to a blank txt document. Example text is below. I appreciate any help I can get with this.


"111111","02","111476","Customer1","xxS48","001535 32601","111210","101110","1740.00",".00","011513", "P",2013-03-28 13:20,"S","","","044LP","111476","LAK"

"222222","02","111089","Customer2","xx2584","00153 270702","111610","081110","540.10",".00","092712", "P",2013-03-27 10:33,"O","","","044LP","111089","LAK" ]]> DOS Command Shell dspencer5 http://www.petri.co.il/forums/showthread.php?t=63091 Need to delete files from sub folders but not from the root http://www.petri.co.il/forums/showthread.php?t=62623&goto=newpost Tue, 05 Feb 2013 23:23:07 GMT Hi Folks,
I've been requested by the powers that be to find away to clean up some files left by one of our software suites.

So the scenario is:
I have a folder
This folder has a bunch of important files in it
Within the folder are a number of sub folders
Within these sub folders are a bunch of temp files that are not important.

So I need to be able to remove all files within the sub folders but leave the files in the root of that folder intact.
The sub folders don't need to be deleted either, they can stay put.

So I was looking at something similar to:
Code:
del /S /Q /F "C:\folder"
But I know that this would remove the files in the root of the folder.
I thought this might have been a good way to go
Code:
del /S /Q /F "C:\folder\*\*"
But del doesn't seem to like wildcards for directories.
Same applies with robocopy. I thought I might be able to robocopy the files to a temp folder and then run the first del command above but I just got a parameter error.
Code:
robocopy "C:\Users\tlane\Desktop\New folder" "C:\Users\tlane\Desktop\newfolderpurge" /S /MOV /XF "C:\Users\tlane\Desktop\New folder" /R:1 /W:1
or
Code:
robocopy "C:\Users\tlane\Desktop\New folder\*\*" "C:\Users\tlane\Desktop\newfolderpurge" /S /MOV /R:1 /W:1
So that's about the extent of my ability to code.
If someone has a better suggestion I'd be appreciative.

If needed this could also be a vbscript if that works better.
Appreciate the help.

Trent ]]> DOS Command Shell Trentl http://www.petri.co.il/forums/showthread.php?t=62623 Please help with code http://www.petri.co.il/forums/showthread.php?t=62604&goto=newpost Sun, 03 Feb 2013 21:26:41 GMT If someone could please help me with batch script code to do the following I'd appreciate it.

I have a comma delimited text file called "stats_record.txt" that contains about 10,000 lines
each line is in the following format with different values for each field in each line.

01a,3,2,2,12,13,02,08,11

I need to be able to read the file and place the 9 fields into variables in a batch file i want to call the variables field1 thru field 9 and then output a new text file called "stats_out.txt" which will create the same number of lines but will assign the fields to peoples names

Each line will have a name associated with each field and that name along with the field will be written to the out put file


So the first output record will look like this


Mary 01a,Bob 3,Charlie 2,Tina 2 ,Rachel 12,Jose 13,Louis 2,Don 8,Paul 11.

in the records that follow, Mary will always be assigned to the values in field 1, bob field 2 Charlie field 3 etc.

Thanks a lot in advance :)
Ed ]]> DOS Command Shell edwite777 http://www.petri.co.il/forums/showthread.php?t=62604