How can I add various strings that appear in a text file?
I would like a script to look at a text file, line by line, and where it finds the following strings, it should add the amount which immediately follows.
A sample of what part of the lines might look like are the following.
..
..
LO1**540*CA*45.0500** etc..
..
LO1**200*CA*27.1200**etc..
..
Whenever the script sees a line which starts with LO1, it should then take the number that follows the two ** and then multiply it by the next number which appears in the line. In the above case, the first line would be 540*45.05.. and so forth for every line.
The resulting data should be the total of all the multiplied lines in a new text file, which perhaps shows the first line of data which was found in the file, and then maybe on the second line, it should show the total.
For instance, the contents of the new text could be..
contents of the first line in the file
Total Dollar Value: $29751.00
A sample of what part of the lines might look like are the following.
..
..
LO1**540*CA*45.0500** etc..
..
LO1**200*CA*27.1200**etc..
..
Whenever the script sees a line which starts with LO1, it should then take the number that follows the two ** and then multiply it by the next number which appears in the line. In the above case, the first line would be 540*45.05.. and so forth for every line.
The resulting data should be the total of all the multiplied lines in a new text file, which perhaps shows the first line of data which was found in the file, and then maybe on the second line, it should show the total.
For instance, the contents of the new text could be..
contents of the first line in the file
Total Dollar Value: $29751.00
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
PowerShell may not be the best option, however I can try. It's s Windows 8 os.
In case you haven't worked with PS yet, basically the first thing you need to do is open a PS console and enter (you have tab completion for commands and most arguments)
More information about this is available using
Set-ExecutionPolicy -ExecutionPolicy RemoteSigned -Scope CurrentUserMore information about this is available using
Get-Help about_Execution_Policies -ShowWindowGet-Help about_Command_Precedence -ShowWindowASKER
Should I try this first and then I can ask for a Powershell script?
Should I try this first and then I can ask for a Powershell script?Sorry, you've lost me.
The script in http:#a40313752 is a Powershell script. Save it as Whatever.ps1 (adjusting the file names, if required), for example in C:\Data.
Then open a Powershell console, and enter (copy and paste will work)
Set-ExecutionPolicy -ExecutionPolicy RemoteSigned -Scope CurrentUser -ForceSet-Location C:\Data.\Whatever.ps1ASKER
Thanks. Can I call the script from within a regular .bat file?
Sure; this assumes that the batch script and the ps script are in the same folder (this sets the execution policy only for the execution of the script):
set PSFile=%~dp0Whatever.ps1
PowerShell.exe -ExecutionPolicy Bypass -Command "& '%PSFile%'"ASKER
And when it performs the function of the powershell script will it continue with the rest of the bat file?
Yep; just like (most) other calls to external programs.
ASKER
I use something similar to this batch file.
pushd "C:\Data"
if exist *.txt findstr /c:"LO1**" *.txt >>NewData.txt || del NewData.txt
popd
The output is something that looks like this..
Original.txt:LO1**200*CA*2
Original.txt:LO1**1*CA*7.5
Original.txt:LO1**10*CA*1.
Original.txt:LO1**2*CA*1.5
This is not enough however, I need more, as I need to be able to use the data and get totals, as outline in my initial email above.
Any assistance is appreciated.