How to read the value from a file

Question

1.00/5 (1 vote)

See more:

Hi All,

I need to read the value -0000000334017 from a file and store them as -3340.17 in Vb.net application.How can i do that?Please help.

Thanks.

Posted 13-Feb-13 4:54am

vidkaat

Add a Solution

Comments

Richard C Bishop 13-Feb-13 10:57am

What kind of file? Store it where?

vidkaat 13-Feb-13 10:58am

its a text file and store it in a dataset.

Chris Reynolds (UK) 13-Feb-13 10:59am

Is the value held as a string in your file? Is it the only thing in the file?
If it is a string then using the TryParse functions to convert it into a number and then dividing the result by 100 would be one way of doing it.

vidkaat 13-Feb-13 11:04am

Nope.Its not the only thing in the file i retrieved other data from the file like name,id and stuff.Not sure how to retrieve this value.

I tried row.Substring(87,11) but could not get them.

vidkaat 13-Feb-13 11:07am

I am stroring it as a Double in my dataset.

Chris Reynolds (UK) 13-Feb-13 11:09am

Can you post sample contents of your file?

vidkaat 13-Feb-13 11:09am

I cannot its a confidential file.Sorry.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

*Karthik Harve* · Accepted Answer · 2013-02-13T05:18:00

Hi,

try by writing the below function and pass the text read from the file.

VB

Private Function fnGetNumber(text As String) As Double
	Try
		Return (Convert.ToDouble(text.Trim())) / 100
	Catch ex As Exception
		Return 0.0
	End Try
End Function

this function will the double value and if the text is in correct, this will return 0.0 and also, this will give number with 2 decimal places.

hope it helps.