Jart, let me rephrase your question as I understand it. please tell me whether I am right? You have a file called moneyfile.txt which has lines like 1234.56 93838.32 39373.12 3846356.3 7373.80 you want to add all these numbers and store the resulting number in runningtotal.txt. Is that right? -- Holla.

0

yes, that is exactly it. :-) thanks so much for the assistance you are providng.

0

i was able to kinda get it using the set /a command but it wouldn't add decimals. so i tried parsing the the dollars and cents into two sepperate opperations by adding a few more steps but then i ran into problems with leading zeros. mostly due to 08 and 09 having octal values throwing off set /a command's ability to understand the command. at least i think that's what i read was causing it. like i said, i'm still VERY new at all of this. :-)

0

Thanks again for the help. i will check back tomorrow morning to see if there have been any new replys. :-)

0

jart, Is it safe to assume that all numbers in the file have two decimal points? I mean, in the above example, I have 3846356.3 is that a possible number or will it be 3846356.30 If we can assume that the decimals are always two digit, it is easy to manipulate. just remove the decimal with string operations and then do the arithmetic operation, and after everything, insert the decimal :-) -- Holla.

0

jart, If they all have two decimal points, @echo off setlocal EnableDelayedExpansion set totalled=0 for /f %%A in (moneyfile.txt) do ( set readLine=%%A :StripDecimal set readLine100=!readLine:.=! set /a totalled=!totalled! + readLine100 ) set /a Totalby100 = !totalled! / 100 set /a decimalPts = !totalled! %% 100 Echo total = %Totalby100%.%decimalPts% ====================================================== here is how I tested it: 11:29:06++++C:\holla\bat\t>type moneyfile.txt 1234.56 93838.32 39373.12 3846356.30 7373.80 11:29:09++++C:\holla\bat\t>totalmoney.bat total = 3988176.10 11:29:14++++C:\holla\bat\t> -- Holla.

0

jart, Here is the script that takes care of varying decimal points. It takes your own approach of using vbs to evaluate expression. @echo off setlocal EnableDelayedExpansion cscript.exe //H:cscript set totalled=0 for /f %%A in (moneyfile.txt) do ( eval.vbs //Nologo !totalled!+%%A > evaled.tmp set /p totalled=<evaled.tmp ) Echo !totalled! > runningtotal.txt -- Holla.

0

hi holla, thanks for helping out. i tried the scripts though and neither of them seem to work. i've tried them both on an xp and a windows 2000 pc but had no success. the batch that passes commands to the vbs script does not complete. or at least its going to take so long that it's not practical. i waited several minutes but had no luck. as for the batch script, that's a great idea removing the decimal that way instead of trying to add the dollars and cents sepperately (especially since it would have produced a value higher than one dollar doing it my way so my way had no chance of working). i think that first batch has the best chance of working but it is still not producing anything. i turned the echo on and tested it and found that it was trying to add the variables !totalled! and !readline100! but the line doing it(set /a totalled=!totalled! + readLine100) was missing the exclamation points around the 2nd variable so i thought that would be the only thing to fix but i'm apparently wrong. it still doesn't work. it's producing an error for each loop saying "missing operand". when i look at it echoing the command on each loop, it is actually using the variable names rather than their values in the command. so instead of it reading set /a totalled=0 +12.45 or something like that, it actually reads set /a totalled=!totalled! + !readLine100!. any ideas what might be causing this?

0

jart, My machine is a vista. However, it is important to not have spaces around some variables. Please send your scripts to me as attachments. my gmail id is hollap. that is hollap at gmail dot com. -- Holla.

0