Extracting new filename from WizRenameRecording log

[gEd]

I found the following script (extract) on the forum,

REM last line in logfile is the new filename
For /F "tokens=*" %%i IN (.\logs\WizRenameRecording.log) DO set newName=%%i

However, the last line of the log doesn;t / no longer has the new file name.

Can a clever scripting bunny show me how I can do this (Piece of cake in *nix but my wiindows scripting skills are not good enough).

The line with the new file name is

Result : BBC News at Six

cheers!


==========================================================
WizRenameRecording - Rename recording filenames
Run on: 15/09/2009 18:36 (v0.1.0.3)
==========================================================
Parameters:
[0]: R:\Recordings\BBC News at Six\BBC News at Six_20090915_18001830.ts
[1]: ({episode}{or}{show})
Retrieving entry from Recordings table...
Evalute called.
Source : BBC News at Six
Pattern: ({episode}{or}{show})
Result : BBC News at Six
Rename called.
Source : R:\Recordings\BBC News at Six\BBC News at Six_20090915_18001830.ts
Target : R:\Recordings\BBC News at Six\BBC News at Six.ts
Step1: Rename file- Successful.
Step2: Comskip/support files- 3 comskip/support files renamed.
Step3: Rename thumbnails- 0 thumbnails renamed.
Step4: Update recording table- Successful.
Complete: 15/09/2009 18:36
Return code: 0
==========================================================

[JavaWiz]

Well, I could fix WizRenameRecording to once again print result at end of file (which I will next time I'm in the code), or....

If you install Win 2003 Server Resource Kit from Microsoft, you will find several batch tools that will help.

In particular there is a program called qgrep, that is like the unix grep comamnd.

You could put the command:

qgrep -e "Target :" WizRenameRecording.log > temp.txt
or use "Result :" for the search string if you like...

Then perform the for script you noted (against the temp.txt file) to pull out the last filename.

To remove the Result : or Target : eyecatcher,

change the
set newName=%%i
to
set newName=%%i:~9

To set newName from postion 10 thru end of line effectively removing the eyeCatcher...

For example:

Code:

REM last line in logfile is the new filename
qgrep -e "Target :" .\logs\WizRenameRecording.log > temp.txt
For /F "tokens=*" %%i IN (temp.txt) DO set tempName=%%i
set newName=%tempName:~9%

You may have to play around with above scripting as I have not tested it but it should work (or be pretty close).

[gEd]

many thanks JW.

Instead of exporting name at end of log perhaps you could have a -x [filename] option that exports newname to [filename]

Just a small thought.

I will play with qgrep, I'm sure it will work fine.

cheers!