Re: add numbers in file

Im reading the file fine, its the adding up the column I need help with.
I'm reading the file and inserting the data into a table. but now i need to
Total the sale price column and insert that into a new column
"glenn" <ghan***@xxxxxxxxxxxxxxxxxx> wrote in message
news:elDape0RFHA.1396@xxxxxxxxxxxxxxxxxxxxxxx
> Here are the very basics to get you started
> this will open a file with specified path and name of settings.txt
> StreamReader sr1 = File.OpenText( path + \\settings.txt);
> String input;
> //read through file and retreive info
> string st = "";
> while ((input=sr1.ReadLine())!=null)
> {
> st = input;
> from here you just need to parse the string value held in st to look for
> your field. I don't know what to tell you here, if its a space delimited
> field then its really easy as all you have to do is give it a start and
end
> location through the use of the st.substring function to grab what you
need.
> Then to do the cast to the double for the purposes of adding up your
values
> you can use the Convert function...
> }
>
> good luck,
>
> "microsoft.news.com" <CSharpCoder> wrote in message
> news:eCajtI0RFHA.580@xxxxxxxxxxxxxxxxxxxxxxx
> > since i never done this before, do you have a snippet or can you point
me
> to
> > an example of this being done?
> >
> >
> > "glenn" <ghan***@xxxxxxxxxxxxxxxxxx> wrote in message
> > news:unD$NE0RFHA.248@xxxxxxxxxxxxxxxxxxxxxxx
> > > I'm not quite sure I follow the question here but I'll take a stab.
If
> I
> > > don't understand then I'm sorry.
> > >
> > > First of all there is no way to just ask the computer what the total
is
> > for
> > > column 2. However, you can write a function that will open the text
> file,
> > > read the file in one line at the time, grabbing the second column and
> > > converting it to a double or currency and then getting the next line.
> > >
> > > The text file is going to read in a string for each line that you will
> > have
> > > to parse to get to the 2nd column which looks quite easy if this is
the
> > > format of your file. But you still have a string when you parse it so
> you
> > > will need to cast it as a double or currency in order to add it up as
a
> > > number value.
> > >
> > > So from my point of view the problem is quite easily obtainable.
> > >
> > > Good luck,
> > >
> > > glenn
> > >
> > > "microsoft.news.com" <CSharpCoder> wrote in message
> > > news:uXICU0zRFHA.3052@xxxxxxxxxxxxxxxxxxxxxxx
> > > > I have a text file that has a column of numbers that i need to add
to
> > get
> > > a
> > > > total of. Is there any way to add the number column in my text file?
> > > >
> > > > the text file looks like this:
> > > >
> > > > BMW 25,252.00 1/1/2005
> > > > BMW 19,000.00 3/15/2005
> > > >
> > > >
> > > > I need to add the money colum to get 44,252.00. is that even
possible
> > from
> > > a
> > > > text file?
> > > >
> > > >
> > >
> > >
> >
> >
>
>


.

Loading