Replace text string using batch file

Here's a revised copy of the original that only changes the MailboxName entry in section 4:

@echo off

setlocal enabledelayedexpansion

set un=%~1

if "%un%"=="" set un=%username%

set /a pos=1

:NEXTCHAR

if "!un:~%pos%,1!"=="" echo Parsing error&goto :EOF

for %%a in (A B C D E F G H I J K L M N O P Q R S T U V W X Y Z) do (
  if "!un:~%pos%,1!"=="%%a" (
    set /a pos+=1
    goto NEXTCHAR
  )  
)

set /a pos-=1

set mailboxName=!un:~%pos%! %un:~0,1%

REM ** Change this part
set inFile="C:\temp\temp\V1.prf"
set outFile="C:\temp\temp\V1a.prf"
set workFile="temp.txt"

>%workFile% find /N /V "_STM_STM_" %inFile%

if exist %outFile% del %outFile% >NUL

set /a lineCnt=0

set inSection4=

for /f "skip=2 tokens=1,2 delims==" %%a in ('type %workFile% 2^>NUL') do call :PROCESS "%%a" "%%b"

if exist %workFile% del %workFIle% >NUL

echo Output in %outFile%

goto :EOF

:STRIPLINENUMBER

set str=%~1

:SLN_NEXTCHAR

if "%str:~0,1%"=="]" goto GOTLINE

set str=%str:~1%
goto SLN_NEXTCHAR

:GOTLINE

set str=%str:~1%

goto :EOF

:SETSECTION

if %1==4 (
  set inSection4=Y
) else (
  set inSection4=
)

goto :EOF

:PROCESS

set /a lineCnt+=1

echo Processing line %lineCnt%

if "%~2"=="" goto NOVALUE

set valuePart=%~2

if "%inSection4%"=="Y" for /f "tokens=2 delims=] " %%a in ('echo %~1 2^>NUL') do if "%%a"=="MailboxName" set valuePart=%mailboxName%

CALL :STRIPLINENUMBER "%~1"

>>%outFile% echo %str%=%valuePart%

goto :EOF

:NOVALUE

for /f "tokens=2,3" %%a in ('echo %~1 2^>NUL') do if "%%a"=="Section" call :SETSECTION "%%b"

call :STRIPLINENUMBER "%~1"

if "%str%"=="" (
  echo.>>%outFile%
  goto :EOF
)

>>%outFile% echo %str%

Good Luck,
Steve

Cheers for that Steve, wasn't sure I would get a repsonse from you so was just trying to make it simple for whoever picked it up.

The new version seems to change just section 4 fine but it doesn't convert JBloggs into Bloggs J anymore.  Coming back with JBloggs still.

Also out of interest when the file runs it shows which line it's processing.  Is it possible to get it to stay on one line and count up instead of showing a new one for each?

Obvioulsy not the most important thing so no worries if you can't!  If you can then I shall raise the value of the question.

Neil

Bug in new code. I didn't have quotes around the 4 in SETSECTION:

@echo off

setlocal enabledelayedexpansion

set un=%~1

if "%un%"=="" set un=%username%

set /a pos=1

:NEXTCHAR

if "!un:~%pos%,1!"=="" echo Parsing error&goto :EOF

for %%a in (A B C D E F G H I J K L M N O P Q R S T U V W X Y Z) do (
  if "!un:~%pos%,1!"=="%%a" (
    set /a pos+=1
    goto NEXTCHAR
  )  
)

set /a pos-=1

set mailboxName=!un:~%pos%! %un:~0,1%

REM ** Change this part
set inFile="C:\temp\temp\V1.prf"
set outFile="C:\temp\temp\V1a.prf"
set workFile="temp.txt"

>%workFile% find /N /V "_STM_STM_" %inFile%

if exist %outFile% del %outFile% >NUL

set /a lineCnt=0

set inSection4=

for /f "skip=2 tokens=1,2 delims==" %%a in ('type %workFile% 2^>NUL') do call :PROCESS "%%a" "%%b"

if exist %workFile% del %workFIle% >NUL

echo Output in %outFile%

goto :EOF

:STRIPLINENUMBER

set str=%~1

:SLN_NEXTCHAR

if "%str:~0,1%"=="]" goto GOTLINE

set str=%str:~1%
goto SLN_NEXTCHAR

:GOTLINE

set str=%str:~1%

goto :EOF

:SETSECTION

if %1=="4" (
  set inSection4=Y
) else (
  set inSection4=
)

goto :EOF

:PROCESS

set /a lineCnt+=1

echo Processing line %lineCnt%

if "%~2"=="" goto NOVALUE

set valuePart=%~2

if "%inSection4%"=="Y" for /f "tokens=2 delims=] " %%a in ('echo %~1 2^>NUL') do if "%%a"=="MailboxName" set valuePart=%mailboxName%

CALL :STRIPLINENUMBER "%~1"

>>%outFile% echo %str%=%valuePart%

goto :EOF

:NOVALUE

for /f "tokens=2,3" %%a in ('echo %~1 2^>NUL') do if "%%a"=="Section" call :SETSECTION "%%b"

call :STRIPLINENUMBER "%~1"

if "%str%"=="" (
  echo.>>%outFile%
  goto :EOF
)

>>%outFile% echo %str%

As for the other stuff, it is possible, but would require more processing and take longer.

Here's an update with the one line progress information:

@echo off

setlocal enabledelayedexpansion

set un=%~1

if "%un%"=="" set un=%username%

set /a pos=1

:NEXTCHAR

if "!un:~%pos%,1!"=="" echo Parsing error&goto :EOF

for %%a in (A B C D E F G H I J K L M N O P Q R S T U V W X Y Z) do (
  if "!un:~%pos%,1!"=="%%a" (
    set /a pos+=1
    goto NEXTCHAR
  )  
)

set /a pos-=1

set mailboxName=!un:~%pos%! %un:~0,1%

REM ** Change this part
set inFile="C:\temp\temp\V1.prf"
set outFile="C:\temp\temp\V1a.prf"
set workFile="temp.txt"

>%workFile% find /N /V "_STM_STM_" %inFile%

if exist %outFile% del %outFile% >NUL

set /a lineCnt=0

set inSection4=

:: *** In the next line, the variable BS needs to be set to a backspace.
:: *** To do this, open the script in edit ("edit progressclock.cmd" in a command window).
:: *** Position the cursor directly after "BS="; enter <Ctrl-P>; in the status bar at the bottom,
:: *** it will display something like "Enter the control sequence to be inserted"; now hit <BackSpace>
:: *** or <Ctrl-H>; a square white symbol with a circle should appear. Save the file and quit edit.
set BS=

for /f "skip=2 tokens=1,2 delims==" %%a in ('type %workFile% 2^>NUL') do call :PROCESS "%%a" "%%b"

if exist %workFile% del %workFIle% >NUL

echo.
echo Output in %outFile%

goto :EOF

:STRIPLINENUMBER

set str=%~1

:SLN_NEXTCHAR

if "%str:~0,1%"=="]" goto GOTLINE

set str=%str:~1%
goto SLN_NEXTCHAR

:GOTLINE

set str=%str:~1%

goto :EOF

:SETSECTION

if %1=="4" (
  set inSection4=Y
) else (
  set inSection4=
)

goto :EOF

:PROCESS

set /a lineCnt+=1

<NUL set /p Dummy=%BS%%BS%%BS%%BS%%BS%%BS%%BS%%BS%%BS%%BS%%BS%%BS%%BS%%BS%%BS%%BS%%BS%%BS%%BS%%BS%Processing line %lineCnt%

REM echo Processing line %lineCnt%

if "%~2"=="" goto NOVALUE

set valuePart=%~2

if "%inSection4%"=="Y" for /f "tokens=2 delims=] " %%a in ('echo %~1 2^>NUL') do if "%%a"=="MailboxName" set valuePart=%mailboxName%

CALL :STRIPLINENUMBER "%~1"

>>%outFile% echo %str%=%valuePart%

goto :EOF

:NOVALUE

for /f "tokens=2,3" %%a in ('echo %~1 2^>NUL') do if "%%a"=="Section" call :SETSECTION "%%b"

call :STRIPLINENUMBER "%~1"

if "%str%"=="" (
  echo.>>%outFile%
  goto :EOF
)

>>%outFile% echo %str%

Doesn't take any longer. For some reason I read your original request incorrectly and thought you wanted to count down to 0.

Steve that has worked perfectly and this time I actually tested it properly (I think!!).

As you probably know by now this is all because we are migrating from windows NT to XP and we need a quick and easy way to be able to create new user profiles.  Along with this section that creates the PRF file I have a part in my logon script that adds a registry key to say run the newly created PRF file once.  My issue now is that because it runs the registry key each time the user logs on it looks to run the PRF file again and therefore resetting any changes the user may have made.  Do you have any ideas how I might get round this?

I don't know if it possible to send a standard e-mail once the user logs on to a generic account that my colleagues and I look at to remind us to now remove them from the logon script or......

If through Regedit you can ask it to look for an exsisting key.  If it's there then it doesn't need to run?

Alternatively if it's possible to get the batch file to check for a particular file on the users home directory before it runs the registry key and then afterwards to create the file so next time it doesn't need to run it?

If you can help with this I'll up the points to 750.

Cheers,

Neil