jasonboetcher
asked on
Problem w/DOS Escape Character ^
I have the following script; all lines print to the output file except for the Prompt19 line and I don't understand why.
REM Put currentDate into YYYY-MM-DD format
REM Put firstDayOfMonth into YYYY-MM-DD format
REM Put currentYear into YYYY format
for /F "tokens=2-4 delims=/ " %%A in ('date/T') do (
set currentDate=%%C-%%A-%%B
set firstDayOfMonth=%%C-%%A-01
set currentYear=%%C
)
REM Put currentMonth in MMM format
REM https://www.experts-exchange.com/questions/21174359/DOS-MMM-Date-Format.html#12352023
for /f "tokens=2 delims=/ " %%a in ('date /t') do (
if "%%a" == "1" set currentMonth=JAN
if "%%a" == "2" set currentMonth=FEB
if "%%a" == "3" set currentMonth=MAR
if "%%a" == "4" set currentMonth=APR
if "%%a" == "5" set currentMonth=MAY
if "%%a" == "6" set currentMonth=JUN
if "%%a" == "7" set currentMonth=JUL
if "%%a" == "8" set currentMonth=AUG
if "%%a" == "9" set currentMonth=SEP
if "%%a" == "10" set currentMonth=OCT
if "%%a" == "11" set currentMonth=NOV
if "%%a" == "12" set currentMonth=DEC
)
REM Use the ^ character to allow the | to be written to the output file.
REM https://www.experts-exchange.com/questions/21173759/DOS-Echo-a-Bar-Character.html
cd d:\impromptu\reprunner
echo [Catalog]>>hnb_monthly_rep
echo catalog1 = d:\impromptu\catalog\new_m
echo catname1 = user>>hnb_monthly_reprunne
echo catpwd1 = >>hnb_monthly_reprunner.in
echo dbname1 = rgw_user>>hnb_monthly_repr
echo dbpwd1 = intranet>>hnb_monthly_repr
echo [Daily Reports]>>hnb_monthly_repr
echo Report1=d:\impromptu\bin\a
echo Prompt1=%currentDate%^|%cu
echo Report2=d:\impromptu\bin\c
echo Prompt2=%currentDate%>>hnb
echo Report3=d:\impromptu\bin\c
echo Prompt3=%currentMonth%^|%c
echo Report4=d:\impromptu\bin\f
echo Prompt4=%currentDate%>>hnb
echo Report5=d:\impromptu\bin\g
echo Prompt5=%currentDate%>>hnb
echo Report6=d:\impromptu\bin\g
echo Prompt6=%currentDate%>>hnb
echo Report7=d:\impromptu\bin\o
echo Prompt7=%currentDate%^|%cu
echo Report8=d:\impromptu\bin\o
echo Prompt8=15>>hnb_monthly_re
echo Report9=d:\impromptu\bin\o
echo Prompt9=%currentDate%>>hnb
echo Report10=d:\impromptu\bin\
echo Prompt10=%firstDayOfMonth%
echo Report11=d:\impromptu\bin\
echo Prompt11=2000-01-01^|%curr
echo Report12=d:\impromptu\bin\
echo Prompt12=%currentDate%^|%c
echo Report13=d:\impromptu\bin\
echo Prompt13=%currentDate%>>hn
echo Report14=d:\impromptu\bin\
echo Prompt14=%currentDate%^|%c
echo Report15=d:\impromptu\bin\
echo Prompt15=%currentDate%>>hn
echo Report16=d:\impromptu\bin\
echo Prompt16=%currentDate%^|AL
echo Report17=d:\impromptu\bin\
echo Prompt17=%currentDate%>>hn
echo Report18=d:\impromptu\bin\
echo Prompt18=%currentDate%>>hn
echo Report19=d:\impromptu\bin\
echo Prompt19=ALL^|2003-01-01^|
echo Report20=d:\impromptu\bin\
echo Prompt20=%currentDate%>>hn
echo Report21=d:\impromptu\bin\
echo Prompt21=%currentDate%>>hn
echo Report22=d:\impromptu\bin\
echo Prompt22=%currentDate%^|%c
echo Report23=d:\impromptu\bin\
echo Prompt23=%currentDate%^|%c
echo Report24=d:\impromptu\bin\
echo Prompt24=%currentDate%^|%c
echo Report25=d:\impromptu\bin\
echo Prompt25=%currentDate%^|50
REM Put currentDate into YYYY-MM-DD format
REM Put firstDayOfMonth into YYYY-MM-DD format
REM Put currentYear into YYYY format
for /F "tokens=2-4 delims=/ " %%A in ('date/T') do (
set currentDate=%%C-%%A-%%B
set firstDayOfMonth=%%C-%%A-01
set currentYear=%%C
)
REM Put currentMonth in MMM format
REM https://www.experts-exchange.com/questions/21174359/DOS-MMM-Date-Format.html#12352023
for /f "tokens=2 delims=/ " %%a in ('date /t') do (
if "%%a" == "1" set currentMonth=JAN
if "%%a" == "2" set currentMonth=FEB
if "%%a" == "3" set currentMonth=MAR
if "%%a" == "4" set currentMonth=APR
if "%%a" == "5" set currentMonth=MAY
if "%%a" == "6" set currentMonth=JUN
if "%%a" == "7" set currentMonth=JUL
if "%%a" == "8" set currentMonth=AUG
if "%%a" == "9" set currentMonth=SEP
if "%%a" == "10" set currentMonth=OCT
if "%%a" == "11" set currentMonth=NOV
if "%%a" == "12" set currentMonth=DEC
)
REM Use the ^ character to allow the | to be written to the output file.
REM https://www.experts-exchange.com/questions/21173759/DOS-Echo-a-Bar-Character.html
cd d:\impromptu\reprunner
echo [Catalog]>>hnb_monthly_rep
echo catalog1 = d:\impromptu\catalog\new_m
echo catname1 = user>>hnb_monthly_reprunne
echo catpwd1 = >>hnb_monthly_reprunner.in
echo dbname1 = rgw_user>>hnb_monthly_repr
echo dbpwd1 = intranet>>hnb_monthly_repr
echo [Daily Reports]>>hnb_monthly_repr
echo Report1=d:\impromptu\bin\a
echo Prompt1=%currentDate%^|%cu
echo Report2=d:\impromptu\bin\c
echo Prompt2=%currentDate%>>hnb
echo Report3=d:\impromptu\bin\c
echo Prompt3=%currentMonth%^|%c
echo Report4=d:\impromptu\bin\f
echo Prompt4=%currentDate%>>hnb
echo Report5=d:\impromptu\bin\g
echo Prompt5=%currentDate%>>hnb
echo Report6=d:\impromptu\bin\g
echo Prompt6=%currentDate%>>hnb
echo Report7=d:\impromptu\bin\o
echo Prompt7=%currentDate%^|%cu
echo Report8=d:\impromptu\bin\o
echo Prompt8=15>>hnb_monthly_re
echo Report9=d:\impromptu\bin\o
echo Prompt9=%currentDate%>>hnb
echo Report10=d:\impromptu\bin\
echo Prompt10=%firstDayOfMonth%
echo Report11=d:\impromptu\bin\
echo Prompt11=2000-01-01^|%curr
echo Report12=d:\impromptu\bin\
echo Prompt12=%currentDate%^|%c
echo Report13=d:\impromptu\bin\
echo Prompt13=%currentDate%>>hn
echo Report14=d:\impromptu\bin\
echo Prompt14=%currentDate%^|%c
echo Report15=d:\impromptu\bin\
echo Prompt15=%currentDate%>>hn
echo Report16=d:\impromptu\bin\
echo Prompt16=%currentDate%^|AL
echo Report17=d:\impromptu\bin\
echo Prompt17=%currentDate%>>hn
echo Report18=d:\impromptu\bin\
echo Prompt18=%currentDate%>>hn
echo Report19=d:\impromptu\bin\
echo Prompt19=ALL^|2003-01-01^|
echo Report20=d:\impromptu\bin\
echo Prompt20=%currentDate%>>hn
echo Report21=d:\impromptu\bin\
echo Prompt21=%currentDate%>>hn
echo Report22=d:\impromptu\bin\
echo Prompt22=%currentDate%^|%c
echo Report23=d:\impromptu\bin\
echo Prompt23=%currentDate%^|%c
echo Report24=d:\impromptu\bin\
echo Prompt24=%currentDate%^|%c
echo Report25=d:\impromptu\bin\
echo Prompt25=%currentDate%^|50
Lee W, MVP
I just cut and past your exact line and didn't have a problem with it. Try as a single line and see if it works for you.
ASKER
I did the echo as a line command and it works as well; try pasting it into a .bat file and running it and look at the output. The line in question is missing.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I'm not sure I understand why this works but it does; thanks!