Tom's Guide | Tom's Hardware | Tom's Games
 |
 |
 |
I need to create a script or batch file that will accept a value as input and then use that value to modify an .INI file. I have a customer that wants to do a uniform price increase/decrease of a certain percent on products. The POS system they use keeps track of pricing using an ini file named "Quality_Pricing.ini". For example, the customer wants to increase prices by 3%, the script/batch file should ask for the price change to be input by the customer, then the script/batch file should make a backup of the original ini. It should then read through all the lines of the ini file and modify the dollar amounts of each line by the percent that was entered. Then it should save the file using the original name "Quality_Pricing.ini". Here is an example of one of the lines from the ini, 002-02=3.99. The first number is a department code, the second is the pricing level, and the third is the actual price that would be modified. I am new to this scripting thing and am not sure I can get this done in the time alotted. If there is anyone that can help me out or point me in the right direction I would greatly appreciate it.
Thanks.
Need a bit more info... When the increase calculated is say 23.51 cents should this be rounded to 24 cents. If yes, at what point does rounding start, does your customer round down .01 thru' .50 and round up .51 thru' .99?
Also, does your customer need the facility to increase/decrease prices by less than 1% (say .5% or .75%) or say 1.5% or 43.23% etc.
Also please confirm the operating system being used by your customer, XP Home or Pro?
0 
Yes, round down .01 thru .50 and up .51 thru .99. All price changes will be done in full percentages. I can email you a copy of the full .ini file to be modified if it will help.
Thanks
0
No need for the .ini file copy, have already generated a test file using the info you gave that each record consists of dept code (3 digits) pricing level (2 digits) and finally the price.
Please respond to my query about the Operating System.
0
Sorry, I forgot to include the OS. The workstation is using XP. Thanks for your help. It is really appreciated!
0
Below is a beta version of what I think you want. It won't update the QP.INI file but will display results on-screen so that you can check if the script is doing what's required. It's up to you to test and retest. No doubt you will want to clean up the script or comment it further. QB.INI seems like an important file in the operation so I have coded a couple of checks on the user input and given a couple of opportunities to cancel before files are updated. A backup file is created each time the script is run but I haven't included any method of purging old backups, neither have I coded a .LOG file which would show when the script was run and the user entries at that time. Good luck.
Updated code begins........ @echo off cls setlocal enabledelayedexpansion :: Get user inputs & check for accuracy.. :: If an input is outside an acceptable range the job is aborted.. echo.&echo.&echo.&echo.&echo.&echo.&echo.&echo.&echo. set /P op= INCREASE OR DECREASE PRICES? (I/D)... if %op% equ I set iord=+ & set updown=INCREASE& cls & goto percentage if %op% equ D set iord=- & set updown=DECREASE& cls & goto percentage set errormsge=I or D (case sensitive) :error cls echo.&echo.&echo.&echo.&echo.&echo.&echo.&echo.&echo. echo INVALID ENTRY "%op%" echo ENTRY FORMAT IS %errormsge% echo. echo JOB TERMINATED.. echo FILES HAVE NOT BEEN COPIED OR AMENDED echo. echo PRESS ANY KEY TO CONTINUE... pause > nul cls exit/b :percentage echo.&echo.&echo.&echo.&echo.&echo.&echo.&echo.&echo. set/P op= WHAT PERCENTAGE PRICE %updown%? (1 thru' 100).. :: Check for non-numeric characters in percentage. echo %op%|findstr /r "[^0-9]" > nul if %errorlevel% equ 0 ( set errormsge=1 thru 100 ^(non-numeric chars not permitted^) & goto error ) :: Check percentage is within the range 1 thru' 100 if %op% gtr 0 if %op% lss 101 ( goto accept ) else ( set errormsge=1 thru' 100 & goto error ) :: User warnings.. :accept cls set notproceed=YOU HAVE OPTED NOT TO PROCEED. set notproceed1=FILES HAVE NOT BEEN COPIED OR UPDATED. set notproceed2=THE CURRENT PRICING FILE REMAINS INTACT. set notproceed3=ENTER C TO RETURN TO WINDOWS. set choices=YOU HAVE CHOSEN TO %UPDOWN% ALL PRICES BY %OP%%%. set choices1=PLEASE CONFIRM OR CANCEL. echo.&echo.&echo.&echo.&echo.&echo.&echo.&echo.&echo. echo %choices% echo.&echo. echo %choices1% echo.&echo. set/p choice= ENTER Y TO CONFIRM, C TO CANCEL.. cls if %choice% equ Y ( goto continue ) else ( echo.&echo.&echo.&echo.&echo.&echo.&echo.&echo.&echo. echo %notproceed% echo %notproceed1% echo.&echo. echo %notproceed3% pause > nul cls exit/b ) :continue cls echo.&echo.&echo.&echo.&echo.&echo.&echo.&echo.&echo. echo FINAL CHANCE TO ABORT CHANGES..... echo ================================== echo.&echo. echo %choices% echo.&echo. echo %choices1% echo.&echo. set/p choice= ENTER Y TO CONFIRM, C TO CANCEL.. cls if %choice% equ Y ( goto proceed ) else ( echo.&echo.&echo.&echo.&echo.&echo.&echo.&echo.&echo. echo %notproceed% echo %notproceed1% echo %notproceed2% echo.&echo. echo %notproceed3% pause > nul cls exit/b ) :proceed cls echo.&echo.&echo.&echo.&echo.&echo.&echo.&echo.&echo. echo File Quality_Pricing.ini will be copied for backup echo and a new file created with changes applied. echo.&echo. echo Please wait.... ping -n 4 127.0.0.1 > nul cls :: Create folder for backup files if not already existing if not exist "c:\backups\" md "c:\backups\" :: Get date and time to include in backup filename.. :: Dias De Verano 25.Dec.2008 set vbsfile=%temp%\newdate.vbs echo Newdate = (Date())>%vbsfile% echo DateYear = DatePart("YYYY", Newdate)>>%vbsfile% echo DateMonth = DatePart("M" , Newdate)>>%vbsfile% echo DateDay = DatePart("D" , Newdate)>>%vbsfile% echo WeekOfYear = DatePart("WW" , Newdate)>>%vbsfile% echo DayOfYear = DatePart("Y" , Newdate)>>%vbsfile% echo WeekDayNumber = DatePart("W" , Newdate)>>%vbsfile% echo TodayNameShort = WeekdayName(WeekDayNumber,True)>>%vbsfile% echo TodayNameFull = WeekdayName(WeekDayNumber,False)>>%vbsfile% echo TimeHour = Hour(Time)>>%vbsfile% echo TimeMinute = Minute(Time)>>%vbsfile% echo TimeSecond = Second(Time)>>%vbsfile% echo If TimeHour^<12 Then>>%vbsfile% echo AMorPM="AM">>%vbsfile% echo Else>>%vbsfile% echo AMorPM="PM">>%vbsfile% echo End If>>%vbsfile% echo Wscript.Echo DateYear^&" "^&DateMonth^&" "^&DateDay^&" "^&Week^ OfYear^&" "^&DayOfYear^&" "^&WeekDayNumber^&" "^&Today^ NameShort^&" "^&TodayNameFull^&" "^&TimeHour^&" "^&Time^ Minute^&" "^&TimeSecond^&" "^&AMorPM>>%vbsfile% for /f "tokens=1-12 delims= " %%A in ('cscript //nologo %vbsfile%') do ( set yyyy=%%A set mm=%%B set dd=%%C set hour=%%I set mins=%%J ) del %vbsfile% if %mm% lss 10 set mm=0%mm% if %dd% lss 10 set dd=0%dd% if %hour% lss 10 set hour=0%hour% if %mins% lss 10 set mins=0%mins% set datime=%yyyy%%mm%%dd%_%hour%%mins% :: Copy file, make backup read only, update .ini set outfil=c:\backups\Quality_Pricing_%datime%.bak set infil=c:\quality_pricing.ini copy "%infil%" "%outfil%" > nul attrib +r "%outfil%" echo.&echo.&echo.&echo.&echo.&echo.&echo.&echo.&echo. echo Backup file created.... echo Now updating Quality_Pricing.ini echo.&echo. echo Please wait.... ping -n 4 127.0.0.1 > nul set output=c:\quality_pricing.txt for /f "tokens=1-3 delims=,=" %%1 in (c:\quality_pricing.ini) do ( set first=%%1 set second=%%2 set third=%%3 call :writit ) more < %output% exit/b :writit if %first% equ [QUALITY_LABELS] ( echo %first%>%output% & goto :eof ) if %first:~0,5% equ PRICE ( echo %first%=%second%>>%output% & goto :eof ) if "%second%"=="x" ( echo %first%=%second%>>%output% & goto :eof ) if %first% equ [QUALITY_PRICES] ( echo.>>%output% echo %first%>>%output% & goto :eof ) set amount=%second:.=% if %amount% lss 100 set amount=%amount:~-2% set/a amtpct=%amount%*%op% if %amtpct:~-2% gtr 50 ( set/a finalamt=%amtpct:~0,-2%+1 ) else ( set finalamt=%amtpct:~0,-2% ) set/a penult=%amount%%iord%%finalamt% if %penult% lss 100 set penult=0%penult% set ult=%penult:~0,-2%.%penult:~-2% if not "!third!"=="" set third=,!third! echo !first!=!ult!!third!>>!output! set third= Updated code ends........
0
Thanks so much for your help. I have run the file and it seems to be on the right track but there are some things that I did not forsee. In the ini file there are several lines at the top that have to do with labels not prices. This section starts with the header [QUALITY_LABELS]. There are two lines for each label. Example:
PRICE_LABEL1=Good
PRICE_LABEL1_COLOR=#D6D557;
There are several of these lines. Then we get to the prices which starts with the header [QUALITY_PRICES]. As you know there are 3 sections in each line(000-01=0.79) however I have noticed that several of the lines have a comma after the price followed by a number (000-02=0.99,1) some lines are like this also (000-12=8.99,#). I even found a few like this (020-12=10.99,3#). Then there is a section of 12 lines like this (700-01=x). What are you thoughts on getting around this problem. I need to make sure that these non-numerical lines and characters remain intact. You have been such a GREAT help that I hate to bother you any more but I am kinda stuck on solving this problem. Hope you can bail me out once more. Thanks again, you are AWESOME!!!
0
Here is what the top of the file looks like.
[QUALITY_LABELS]
PRICE_LABEL1=Good
PRICE_LABEL1_COLOR=#D6D557;
PRICE_LABEL2=Better
PRICE_LABEL2_COLOR=#5BD657;
PRICE_LABEL3=Excellent
PRICE_LABEL3_COLOR=#D6575E;
PRICE_LABEL4=REALLY COOL
PRICE_LABEL4_COLOR=#FF0000;
PRICE_LABEL5=GETTING CRAZY
PRICE_LABEL5_COLOR=#FF0000;
PRICE_LABEL6=YAWN
PRICE_LABEL6_COLOR=#FF0000;[QUALITY_PRICES]
000-01=0.79
000-02=0.99,1
000-03=1.49
000-04=1.99,2
000-05=2.49
000-06=2.99,3I would have mentioned this at the start but the customer only gave me a sample of the price lines not the entire file. I have it now and could send you an entire copy of it if that will help. Thank you for all of your time and effort!!!
0
It seems to me that the format of the records might not be static so using a scripting language to update just the prices might not be possible and you should be looking at VB or C++. It doesn't matter if records are added/deleted in the course of processing, it's the FORMAT of the records that's important.
OK, please send me a copy of the entire file and I'll decide whether or not to proceed.
0
Here is the file. I was forced to remove alot of the lines because it was just to long to send as open text on this forum but this will give you the general idea. Thanks again for all of your help.
[QUALITY_LABELS]
PRICE_LABEL1=Good
PRICE_LABEL1_COLOR=#D6D557;
PRICE_LABEL2=Better
PRICE_LABEL2_COLOR=#5BD657;
PRICE_LABEL3=Excellent
PRICE_LABEL3_COLOR=#D6575E;
PRICE_LABEL4=REALLY COOL
PRICE_LABEL4_COLOR=#FF0000;
PRICE_LABEL5=GETTING CRAZY
PRICE_LABEL5_COLOR=#FF0000;
PRICE_LABEL6=YAWN
PRICE_LABEL6_COLOR=#FF0000;[QUALITY_PRICES]
000-01=0.79
000-02=0.99,1
000-03=1.49
000-04=1.99,2
000-05=2.49
000-06=2.99,3
000-07=3.99
000-08=4.99
000-09=5.99
000-10=6.99
000-11=7.99
000-12=8.99,#
001-01=0.79,#
001-02=0.99,#
001-03=1.49,#
001-04=1.99,#
001-05=2.49,#
001-06=2.99,#
001-07=3.99,#
001-08=4.99,#
001-09=5.99,#
001-10=6.99,#
001-11=7.99,#
001-12=8.99,#
002-01=2.99
002-02=3.99
002-03=4.99,1
002-04=5.99
002-05=6.99
002-06=7.99
002-07=8.99,2
002-08=9.99
002-09=10.99
002-10=12.99
002-11=14.99,3
002-12=16.99,#
016-01=0.99
016-02=1.49
016-03=1.99
016-04=2.49,1
016-05=2.99
016-06=3.99
016-07=4.99,2
016-08=5.99
016-09=6.99,3
016-10=7.99
016-11=8.99
016-12=9.99,#
017-01=0.99
017-02=1.49
017-03=1.99
017-04=2.49,1
017-05=2.99
017-06=3.99
017-07=4.99,2
017-08=5.99
017-09=6.99,3
017-10=7.99
017-11=8.99
017-12=9.99,#
018-01=0.99
018-02=1.49
018-03=1.99
018-04=2.49,1
018-05=2.99
018-06=3.99
018-07=4.99,2
018-08=5.99
018-09=6.99,3
018-10=7.99
018-11=8.99
018-12=9.99,#
019-01=0.99
019-02=1.49
019-03=1.99
019-04=2.49,1
019-05=2.99
019-06=3.99
019-07=4.99,2
019-08=5.99
019-09=6.99,3
019-10=7.99
019-11=8.99
019-12=9.99,#
020-01=1.49
020-02=1.99
020-03=2.49
020-04=2.99
020-05=3.99
020-06=4.99,1
020-07=5.99
020-08=6.99
020-09=7.99
020-10=8.99,2
020-11=9.99
020-12=10.99,3#
021-01=1.49
021-02=1.99
021-03=2.49
021-04=2.99
021-05=3.99
021-06=4.99,1
021-07=5.99
021-08=6.99
021-09=7.99
021-10=8.99,2
021-11=9.99
021-12=10.99,3#
022-01=1.49
022-02=1.99
022-03=2.49
022-04=2.99
022-05=3.99
022-06=4.99,1
022-07=5.99
022-08=6.99
022-09=7.99
022-10=8.99,2
022-11=9.99
022-12=10.99,3#
023-01=1.49
023-02=1.99
023-03=2.49
023-04=2.99
023-05=3.99
023-06=4.99,1
023-07=5.99
023-08=6.99
023-09=7.99
023-10=8.99,2
023-11=9.99
023-12=10.99,3#
024-01=2.99
024-02=3.99
024-03=4.99,1
024-04=5.99
024-05=6.99
024-06=7.99
024-07=8.99,2
024-08=9.99
024-09=10.99,3
024-10=12.99
024-11=14.99
024-12=16.99,#
025-01=2.99
025-02=3.99
025-03=4.99,1
025-04=5.99
025-05=6.99
025-06=7.99
025-07=8.99,2
025-08=9.99
025-09=10.99,3
025-10=12.99
025-11=14.99
025-12=16.99,#
026-01=2.99
026-02=3.99
026-03=4.99,1
026-04=5.99
026-05=6.99
026-06=7.99
026-07=8.99,2
026-08=9.99
026-09=10.99,3
026-10=12.99
026-11=14.99
026-12=16.99,#
027-01=2.99
027-02=3.99
027-03=4.99,1
027-04=5.99
027-05=6.99
027-06=7.99
027-07=8.99,2
027-08=9.99
027-09=10.99,3
027-10=12.99
027-11=14.99
027-12=16.99,#
028-01=3.99
028-02=4.99
028-03=5.99
028-04=6.99
028-05=7.99,1
028-06=8.99
028-07=9.99
028-08=10.99
028-09=12.99
028-10=14.99,2
028-11=16.99
028-12=19.99,3#
029-01=3.99
029-02=4.99
029-03=5.99
029-04=6.99
029-05=7.99,1
029-06=8.99
029-07=9.99
029-08=10.99
029-09=12.99
029-10=14.99,2
029-11=16.99
029-12=19.99,3#
030-01=3.99
030-02=4.99
030-03=5.99
030-04=6.99
030-05=7.99,1
030-06=8.99
030-07=9.99
030-08=10.99
030-09=12.99
030-10=14.99,2
030-11=16.99
030-12=19.99,3#
031-01=3.99
031-02=4.99
031-03=5.99
031-04=6.99
031-05=7.99,1
031-06=8.99
031-07=9.99
031-08=10.99
031-09=12.99
031-10=14.99,2
031-11=16.99
031-12=19.99,3#
036-01=1.99
036-02=2.49
036-03=2.99
036-04=3.99,1
036-05=4.99
036-06=5.99
036-07=6.99,2
036-08=7.99
036-09=8.99,3
036-10=9.99
036-11=10.99
036-12=12.99,#
037-01=1.99
037-02=2.49
037-03=2.99
037-04=3.99,1
037-05=4.99
037-06=5.99
037-07=6.99,2
037-08=7.99
037-09=8.99,3
037-10=9.99
037-11=10.99
037-12=12.99,#
038-01=1.99
038-02=2.49
038-03=2.99
038-04=3.99,1
038-05=4.99
038-06=5.99
038-07=6.99,2
038-08=7.99
038-09=8.99,3
038-10=9.99
038-11=10.99
038-12=12.99,#
039-01=1.99
039-02=2.49
039-03=2.99
039-04=3.99,1
039-05=4.99
039-06=5.99
039-07=6.99,2
039-08=7.99
039-09=8.99,3
039-10=9.99
039-11=10.99
039-12=12.99,#
040-01=1.99
040-02=2.49
040-03=2.99
040-04=3.99,1
040-05=4.99
040-06=5.99
040-07=6.99,2
040-08=7.99
040-09=8.99,3
040-10=9.99
040-11=10.99
040-12=12.99,#
041-01=1.99
041-02=2.49
041-03=2.99
041-04=3.99,1
041-05=4.99
041-06=5.99
041-07=6.99,2
041-08=7.99
041-09=8.99,3
041-10=9.99
041-11=10.99
041-12=12.99,#
042-01=1.99
042-02=2.49
042-03=2.99
042-04=3.99,1
042-05=4.99
042-06=5.99
042-07=6.99,2
042-08=7.99
042-09=8.99,3
042-10=9.99
042-11=10.99
042-12=12.99,#
043-01=1.99
043-02=2.49
043-03=2.99
043-04=3.99,1
043-05=4.99
043-06=5.99
043-07=6.99,2
043-08=7.99
043-09=8.99,3
043-10=9.99
043-11=10.99
043-12=12.99,#
044-01=1.99
044-02=2.49
044-03=2.99
044-04=3.99,1
044-05=4.99
044-06=5.99
044-07=6.99,2
044-08=7.99
044-09=8.99,3
044-10=9.99
044-11=10.99
044-12=12.99,#
045-01=1.99
045-02=2.49
045-03=2.99
045-04=3.99,1
045-05=4.99
045-06=5.99
045-07=6.99,2
045-08=7.99
045-09=8.99,3
045-10=9.99
045-11=10.99
045-12=12.99,#
046-01=1.99
046-02=2.49
046-03=2.99
046-04=3.99,1
046-05=4.99
046-06=5.99
046-07=6.99,2
046-08=7.99
046-09=8.99,3
046-10=9.99
046-11=10.99
046-12=12.99,#
047-01=1.99
047-02=2.49
047-03=2.99
047-04=3.99,1
047-05=4.99
047-06=5.99
047-07=6.99,2
047-08=7.99
047-09=8.99,3
047-10=9.99
047-11=10.99
047-12=12.99,#
048-01=1.99
048-02=2.49
048-03=2.99
048-04=3.99,1
048-05=4.99
048-06=5.99
048-07=6.99,2
048-08=7.99
048-09=8.99,3
048-10=9.99
048-11=10.99
048-12=12.99,#
049-01=1.99
049-02=2.49
049-03=2.99
049-04=3.99,1
049-05=4.99
049-06=5.99
049-07=6.99,2
049-08=7.99
049-09=8.99,3
049-10=9.99
049-11=10.99
049-12=12.99,#
050-01=1.99
050-02=2.49
050-03=2.99
050-04=3.99,1
050-05=4.99
050-06=5.99
050-07=6.99,2
050-08=7.99
050-09=8.99,3
050-10=9.99
050-11=10.99
050-12=12.99,#
051-01=1.99
051-02=2.49
051-03=2.99
051-04=3.99,1
051-05=4.99
051-06=5.99
051-07=6.99,2
051-08=7.99
051-09=8.99,3
051-10=9.99
051-11=10.99
051-12=12.99,#
052-01=1.99
052-02=2.49
052-03=2.99
052-04=3.99,1
052-05=4.99
052-06=5.99
052-07=6.99,2
052-08=7.99
052-09=8.99,3
052-10=9.99
052-11=10.99
052-12=12.99,#
053-01=1.99
053-02=2.49
053-03=2.99
053-04=3.99,1
053-05=4.99
053-06=5.99
053-07=6.99,2
053-08=7.99
053-09=8.99,3
053-10=9.99
053-11=10.99
053-12=12.99,#
054-01=1.99
054-02=2.49
054-03=2.99
054-04=3.99,1
054-05=4.99
054-06=5.99
054-07=6.99,2
054-08=7.99
054-09=8.99,3
054-10=9.99
054-11=10.99
054-12=12.99,#
055-01=1.99
055-02=2.49
055-03=2.99
055-04=3.99,1
055-05=4.99
055-06=5.99
055-07=6.99,2
055-08=7.99
055-09=8.99,3
055-10=9.99
055-11=10.99
055-12=12.99,#
056-01=1.99
056-02=2.49
056-03=2.99
056-04=3.99,1
056-05=4.99
056-06=5.99
056-07=6.99,2
056-08=7.99
056-09=8.99,3
056-10=9.99
056-11=10.99
056-12=12.99,#
057-01=1.99
057-02=2.49
057-03=2.99
057-04=3.99,1
057-05=4.99
057-06=5.99
057-07=6.99,2
057-08=7.99
057-09=8.99,3
057-10=9.99
057-11=10.99
057-12=12.99,#
058-01=1.99
058-02=2.49
058-03=2.99
058-04=3.99,1
058-05=4.99
058-06=5.99
058-07=6.99,2
058-08=7.99
058-09=8.99,3
058-10=9.99
058-11=10.99
058-12=12.99,#
059-01=1.99
059-02=2.49
059-03=2.99
059-04=3.99,1
059-05=4.99
059-06=5.99
059-07=6.99,2
059-08=7.99
059-09=8.99,3
059-10=9.99
059-11=10.99
059-12=12.99,#
060-01=1.99
060-02=2.49
060-03=2.99
060-04=3.99,1
060-05=4.99
060-06=5.99
060-07=6.99,2
060-08=7.99
060-09=8.99,3
060-10=9.99
060-11=10.99
060-12=12.99,#
061-01=1.99
061-02=2.49
061-03=2.99
061-04=3.99,1
061-05=4.99
061-06=5.99
061-07=6.99,2
061-08=7.99
061-09=8.99,3
061-10=9.99
061-11=10.99
061-12=12.99,#
062-01=1.99
062-02=2.49
062-03=2.99
062-04=3.99,1
062-05=4.99
062-06=5.99
062-07=6.99,2
062-08=7.99
062-09=8.99,3
062-10=9.99
062-11=10.99
062-12=12.99,#
063-01=1.99
063-02=2.49
063-03=2.99
063-04=3.99,1
063-05=4.99
063-06=5.99
063-07=6.99,2
063-08=7.99
063-09=8.99,3
063-10=9.99
063-11=10.99
063-12=12.99,#
064-01=1.99
064-02=2.49
064-03=2.99
064-04=3.99,1
064-05=4.99
064-06=5.99
064-07=6.99,2
064-08=7.99
064-09=8.99,3
064-10=9.99
064-11=10.99
064-12=12.99,#
065-01=1.99
065-02=2.49
065-03=2.99
065-04=3.99,1
065-05=4.99
065-06=5.99
065-07=6.99,2
065-08=7.99
065-09=8.99,3
065-10=9.99
065-11=10.99
065-12=12.99,#
069-01=1.99
069-02=2.49
069-03=2.99
069-04=3.99,1
069-05=4.99
069-06=5.99
069-07=6.99,2
069-08=7.99
069-09=8.99,3
069-10=9.99
069-11=10.99
069-12=12.99,#
072-01=1.99
072-02=2.49
072-03=2.99
072-04=3.99,1
072-05=4.99
072-06=5.99
072-07=6.99,2
072-08=7.99
072-09=8.99,3
072-10=9.99
072-11=10.99
072-12=12.99,#
073-01=1.99
073-02=2.49
073-03=2.99
073-04=3.99
073-05=4.99,1
073-06=5.99
073-07=6.99
073-08=7.99,2
073-09=8.99
073-10=9.99,3
073-11=10.99
073-12=12.99,#
074-01=1.99
074-02=2.49
074-03=2.99
074-04=3.99
074-05=4.99,1
074-06=5.99
074-07=6.99
074-08=7.99,2
074-09=8.99
074-10=9.99,3
074-11=10.99
074-12=12.99,#
075-01=1.99
075-02=2.49
075-03=2.99
075-04=3.99
075-05=4.99,1
075-06=5.99
075-07=6.99
075-08=7.99,2
075-09=8.99
075-10=9.99,3
075-11=10.99
075-12=12.99,#
076-01=3.99
076-02=4.99
076-03=5.99
076-04=6.99
076-05=7.99,1
076-06=8.99
076-07=9.99
076-08=10.99,2
076-09=12.99
076-10=14.99,3
076-11=16.99
076-12=19.99,#
077-01=3.99
077-02=4.99
077-03=5.99
077-04=6.99
077-05=7.99,1
077-06=8.99
077-07=9.99
077-08=10.99,2
077-09=12.99
077-10=14.99,3
077-11=16.99
077-12=19.99,#
078-01=3.99
078-02=4.99
078-03=5.99
078-04=6.99
078-05=7.99,1
078-06=8.99
078-07=9.99
078-08=10.99,2
078-09=12.99
078-10=14.99,3
078-11=16.99
078-12=19.99,#
079-01=3.99
079-02=4.99
079-03=5.99
079-04=6.99
079-05=7.99,1
079-06=8.99
079-07=9.99
079-08=10.99,2
079-09=12.99
079-10=14.99,3
079-11=16.99
079-12=19.99,#
080-01=3.99
080-02=4.99
080-03=5.99
080-04=6.99
080-05=7.99,1
080-06=8.99
080-07=9.99
080-08=10.99,2
080-09=12.99
080-10=14.99,3
080-11=16.99
080-12=19.99,#
081-01=3.99
081-02=4.99
081-03=5.99
081-04=6.99
081-05=7.99,1
081-06=8.99
081-07=9.99
081-08=10.99,2
081-09=12.99
081-10=14.99,3
081-11=16.99
081-12=19.99,#
082-01=3.99
082-02=4.99
082-03=5.99
082-04=6.99
082-05=7.99,1
082-06=8.99
082-07=9.99
082-08=10.99,2
082-09=12.99
082-10=14.99,3
082-11=16.99
082-12=19.99,#
083-01=3.99
083-02=4.99
083-03=5.99
083-04=6.99
083-05=7.99,1
083-06=8.99
083-07=9.99
083-08=10.99,2
083-09=12.99
083-10=14.99,3
083-11=16.99
083-12=19.99,#
084-01=3.99
084-02=4.99
084-03=5.99
084-04=6.99
084-05=7.99,1
084-06=8.99
084-07=9.99
084-08=10.99,2
084-09=12.99
084-10=14.99,3
084-11=16.99
084-12=19.99,#
085-01=3.99
085-02=4.99
085-03=5.99
085-04=6.99
085-05=7.99,1
085-06=8.99
085-07=9.99
085-08=10.99,2
085-09=12.99
085-10=14.99,3
085-11=16.99
085-12=19.99,#
086-01=4.99
086-02=5.99
086-03=6.98
086-04=7.99
086-05=8.99,1
086-06=9.99
086-07=10.99
086-08=12.99
086-09=14.99,2
086-10=16.99
086-11=19.99,3
086-12=24.99,#
088-01=4.99
088-02=5.99
088-03=6.98
088-04=7.99
088-05=8.99,1
088-06=9.99
088-07=10.99
088-08=12.99
088-09=14.99,2
088-10=16.99
088-11=19.99,3
088-12=24.99,#
090-01=5.99
090-02=6.99
090-03=7.99
090-04=8.99
090-05=9.99
090-06=10.99,1
090-07=12.99
090-08=14.99
090-09=16.99
090-10=19.99,2
090-11=24.99
090-12=29.99,3#
094-01=5.99
094-02=6.99
094-03=7.99
094-04=8.99
094-05=9.99
094-06=10.99,1
094-07=12.99
094-08=14.99
094-09=16.99
094-10=19.99,2
094-11=24.99
094-12=29.99,3#
096-01=5.99
096-02=6.99
096-03=7.99
096-04=8.99
096-05=9.99
096-06=10.99,1
096-07=12.99
096-08=14.99
096-09=16.99
096-10=19.99,2
096-11=24.99
096-12=29.99,3#
097-01=5.99
097-02=6.99
097-03=7.99
097-04=8.99
097-05=9.99
097-06=10.99,1
097-07=12.99
097-08=14.99
097-09=16.99
097-10=19.99,2
097-11=24.99
097-12=29.99,3#
098-01=5.99
098-02=6.99
098-03=7.99
098-04=8.99
098-05=9.99
098-06=10.99,1
098-07=12.99
098-08=14.99
098-09=16.99
098-10=19.99,2
098-11=24.99
098-12=29.99,3#
099-01=5.99
099-02=6.99
099-03=7.99
099-04=8.99
099-05=9.99
099-06=10.99,1
099-07=12.99
099-08=14.99
099-09=16.99
099-10=19.99,2
099-11=24.99
099-12=29.99,3#
100-01=0.49
100-02=0.79,1
100-03=0.99
100-04=1.49,2
100-05=1.99,3
100-06=2.49
100-07=2.99
100-08=3.99
100-09=4.99
100-10=5.99
100-11=6.99
100-12=7.99,#
101-01=0.49,#
101-02=0.79,#
101-03=0.99,#
101-04=1.49,#
101-05=1.99,#
101-06=2.49,#
101-07=2.99,#
101-08=3.99,#
101-09=4.99,#
101-10=5.99,#
101-11=6.99,#
101-12=7.99,#
116-01=0.99
116-02=1.49
116-03=1.99,1
116-04=2.49
116-05=2.99
116-06=3.99,2
116-07=4.99
116-08=5.99,3
116-09=6.99
116-10=7.99
116-11=8.99
116-12=9.99,#
117-01=0.99
117-02=1.49
117-03=1.99,1
117-04=2.49
117-05=2.99
117-06=3.99,2
117-07=4.99
117-08=5.99,3
117-09=6.99
117-10=7.99
117-11=8.99
117-12=9.99,#
118-01=0.99
118-02=1.49
118-03=1.99,1
118-04=2.49
118-05=2.99
118-06=3.99,2
118-07=4.99
118-08=5.99,3
118-09=6.99
118-10=7.99
118-11=8.99
118-12=9.99,#
119-01=0.99
119-02=1.49
119-03=1.99,1
119-04=2.49
119-05=2.99
119-06=3.99,2
119-07=4.99
119-08=5.99,3
119-09=6.99
119-10=7.99
119-11=8.99
119-12=9.99,#
120-01=1.99
120-02=2.49
120-03=2.99
120-04=3.99
120-05=4.99
120-06=5.99,1
120-07=6.99
120-08=7.99
120-09=8.99
120-10=9.99,2
120-11=10.99
120-12=12.99,3#
121-01=1.99
121-02=2.49
121-03=2.99
121-04=3.99
121-05=4.99
121-06=5.99,1
121-07=6.99
121-08=7.99
121-09=8.99
121-10=9.99,2
121-11=10.99
121-12=12.99,3#
122-01=1.99
122-02=2.49
122-03=2.99
122-04=3.99
122-05=4.99
122-06=5.99,1
122-07=6.99
122-08=7.99
122-09=8.99
122-10=9.99,2
122-11=10.99
122-12=12.99,3#
123-01=1.99
123-02=2.49
123-03=2.99
123-04=3.99
123-05=4.99
123-06=5.99,1
123-07=6.99
123-08=7.99
123-09=8.99
123-10=9.99,2
123-11=10.99
123-12=12.99,3#
124-01=2.99
124-02=3.99
124-03=4.99,1
124-04=5.99
124-05=6.99
124-06=8.99,2
124-07=9.99
124-08=10.99,3
124-09=12.99
124-10=14.99
124-11=16.99
124-12=19.99,#
125-01=2.99
125-02=3.99
125-03=4.99,1
125-04=5.99
125-05=6.99
125-06=8.99,2
125-07=9.99
125-08=10.99,3
125-09=12.99
125-10=14.99
125-11=16.99
125-12=19.99,#
126-01=2.99
126-02=3.99
126-03=4.99,1
126-04=5.99
126-05=6.99
126-06=8.99,2
126-07=9.99
126-08=10.99,3
126-09=12.99
126-10=14.99
126-11=16.99
126-12=19.99,#
127-01=2.99
127-02=3.99
127-03=4.99,1
127-04=5.99
127-05=6.99
127-06=8.99,2
127-07=9.99
127-08=10.99,3
127-09=12.99
127-10=14.99
127-11=16.99
127-12=19.99,#
128-01=3.99
128-02=4.99
128-03=5.99
128-04=6.99
128-05=7.99,1
128-06=8.99
128-07=9.99
128-08=10.99
128-09=12.99
128-10=14.99,2
128-11=16.99
128-12=19.99,3#
129-01=3.99
129-02=4.99
129-03=5.99
129-04=6.99
129-05=7.99,1
129-06=8.99
129-07=9.99
129-08=10.99
129-09=12.99
129-10=14.99,2
129-11=16.99
129-12=19.99,3#
130-01=3.99
130-02=4.99
130-03=5.99
130-04=6.99
130-05=7.99,1
130-06=8.99
130-07=9.99
130-08=10.99
130-09=12.99
130-10=14.99,2
130-11=16.99
130-12=19.99,3#
131-01=3.99
131-02=4.99
131-03=5.99
131-04=6.99
131-05=7.99,1
131-06=8.99
131-07=9.99
131-08=10.99
131-09=12.99
131-10=14.99,2
131-11=16.99
131-12=19.99,3#
132-01=2.99
132-02=3.99
132-03=4.99
132-04=5.99,1
132-05=6.99
132-06=8.99
132-07=9.99,2
132-08=10.99
132-09=12.99
132-10=14.99,3
132-11=16.99
132-12=19.99,#
133-01=2.99
133-02=3.99
133-03=4.99
133-04=5.99,1
133-05=6.99
133-06=8.99
133-07=9.99,2
133-08=10.99
133-09=12.99
133-10=14.99,3
133-11=16.99
133-12=19.99,#
140-01=2.49
140-02=2.99
140-03=3.99
140-04=4.99,1
140-05=5.99
140-06=6.99
140-07=7.99
140-08=8.99,2
140-09=9.99
140-10=10.99,3
140-11=12.99
140-12=14.99,#
141-01=2.49
141-02=2.99
141-03=3.99
141-04=4.99,1
141-05=5.99
141-06=6.99
141-07=7.99
141-08=8.99,2
141-09=9.99
141-10=10.99,3
141-11=12.99
141-12=14.99,#
142-01=2.49
142-02=2.99
142-03=3.99
142-04=4.99,1
142-05=5.99
142-06=6.99
142-07=7.99
142-08=8.99,2
142-09=9.99
142-10=10.99,3
142-11=12.99
142-12=14.99,#
143-01=2.49
143-02=2.99
143-03=3.99
143-04=4.99,1
143-05=5.99
143-06=6.99
143-07=7.99
143-08=8.99,2
143-09=9.99
143-10=10.99,3
143-11=12.99
143-12=14.99,#
144-01=2.49
144-02=2.99
144-03=3.99
144-04=4.99,1
144-05=5.99
144-06=6.99
144-07=7.99
144-08=8.99,2
144-09=9.99
144-10=10.99,3
144-11=12.99
144-12=14.99,#
145-01=2.49
145-02=2.99
145-03=3.99
145-04=4.99,1
145-05=5.99
145-06=6.99
145-07=7.99
145-08=8.99,2
145-09=9.99
145-10=10.99,3
145-11=12.99
145-12=14.99,#
146-01=2.49
146-02=2.99
146-03=3.99
146-04=4.99,1
146-05=5.99
146-06=6.99
146-07=7.99
146-08=8.99,2
146-09=9.99
146-10=10.99,3
146-11=12.99
146-12=14.99,#
147-01=2.49
147-02=2.99
147-03=3.99
147-04=4.99,1
147-05=5.99
147-06=6.99
147-07=7.99
147-08=8.99,2
147-09=9.99
147-10=10.99,3
147-11=12.99
147-12=14.99,#
148-01=2.49
148-02=2.99
148-03=3.99
148-04=4.99,1
148-05=5.99
148-06=6.99
148-07=7.99
148-08=8.99,2
148-09=9.99
148-10=10.99,3
148-11=12.99
148-12=14.99,#
149-01=2.49
149-02=2.99
149-03=3.99
149-04=4.99,1
149-05=5.99
149-06=6.99
149-07=7.99
149-08=8.99,2
149-09=9.99
149-10=10.99,3
149-11=12.99
149-12=14.99,#
150-01=2.49
150-02=2.99
150-03=3.99
150-04=4.99,1
150-05=5.99
150-06=6.99
150-07=7.99
150-08=8.99,2
150-09=9.99
150-10=10.99,3
150-11=12.99
150-12=14.99,#
151-01=2.49
151-02=2.99
151-03=3.99
151-04=4.99,1
151-05=5.99
151-06=6.99
151-07=7.99
151-08=8.99,2
151-09=9.99
151-10=10.99,3
151-11=12.99
151-12=14.99,#
152-01=2.49
152-02=2.99
152-03=3.99
152-04=4.99,1
152-05=5.99
152-06=6.99
152-07=7.99
152-08=8.99,2
152-09=9.99
152-10=10.99,3
152-11=12.99
152-12=14.99,#
156-01=2.49
156-02=2.99
156-03=3.99
156-04=4.99,1
156-05=5.99
156-06=6.99
156-07=7.99
156-08=8.99,2
156-09=9.99
156-10=10.99,3
156-11=12.99
556-01=4.99
556-02=5.99
556-03=6.99
556-04=7.99
556-05=8.99
556-06=9.99
556-07=10.99
556-08=12.99
556-09=14.99,1
556-10=16.99
556-11=19.99,2
556-12=24.99,3#
557-01=4.99
557-02=5.99
557-03=6.99
557-04=7.99
557-05=8.99
557-06=9.99
557-07=10.99
557-08=12.99
557-09=14.99,1
557-10=16.99
557-11=19.99,2
557-12=24.99,3#
560-01=4.99
560-02=5.99
560-03=6.99
560-04=7.99
560-05=8.99
560-06=9.99
560-07=10.99
560-08=12.99
560-09=14.99,1
560-10=16.99
560-11=19.99,2
560-12=24.99,3#
600-01=0.49,#
600-02=0.79,#
600-03=0.99,#
600-04=1.49,#
600-05=1.99,#
600-06=2.49,#
600-07=2.99,#
600-08=3.99,#
600-09=4.99,#
600-10=5.99,#
600-11=6.99,#
600-12=7.99,#
601-01=0.49,#
601-02=0.79,#
601-03=0.99,#
601-04=1.49,#
601-05=1.99,#
601-06=2.49,#
601-07=2.99,#
601-08=3.99,#
601-09=4.99,#
601-10=5.99,#
601-11=6.99,#
601-12=7.99,#
602-01=0.49,#
602-02=0.79,#
700-01=x
700-02=x
700-03=x
700-04=x
700-05=x
700-06=x
700-07=x
700-08=x
700-09=x
700-10=x
700-11=x
700-12=x
0
I've reposted the code, hopefully to take into account all the record formats you supplied. When I copy/pasted the records I got four blanks at the start of each one, I'm assuming that these were the result of forum indenting and that they're not present in the QP.ini file. I haven't done much testing, again leaving you to confirm the script is performing as you want.
I'm going bush for three days so will check back on Monday hoping that it's good news day.
V.
0
It works great. I made just a few minor changes but you nailed it!!! Thank you so much for your help. Have a great weekend and I hope to talk to you again.
Thanks again.
Paul
0
Thanks for coming back with your good news. No charge for the assist but a donation to your local Breast Cancer Support Group or Cancer Support Group would, I'm sure, be appreciated.
All the best.
Valerie.
0
Funny you should mention that. Our company does donations to that cause already. I did have one more question. the batch file works great, I have modified it to over write the exisiting INI instead of writing out to a txt file. It works great the first time through but when I try to run it again on the INI that has already been modified I see several "missing opperand" statements and when I look at the ini again the one section that has nothing but x's (700 section) is messed up. Instead of x's it has the price from the last 600 section line in place of all the x's. I am sure I can figure this out but I thought I would get your input as well.
Thanks for all your help.
0
Good on the donation front, your company heads are to be congratulated.
On the problem you've encountered - yes - it's a bug in the code though not a really obvious one. I'll leave you to sweat it out!!!
0
Well, I got it all working! Sorry I didnt let you know sooner. You were a big help and if you were closer I would take you out to dinner!
Thanks again.
0  |
 |
 |
This post is quite old and has been locked from receiving new replies. Please create a new posting instead.
| Ads by Google |
