Formatting a number

eelisMX · January 27th, 2005, 03:41 AM

Hi

Have a problem with formatting a number.
This code works fine:

Code:

Format(mbsize / 1048576, "#,###.## MB")

and format the number with thousand seperator and 2 decimals.

I'm having another number which can vary between 1 and billions (as Long), and I would like to format it with seperators every 3 digits, no decimals. All my trials returned question-mark (?) where the seperator suppose to be.

Any ideas... Thanks!

Eelis

jaucourt · January 27th, 2005, 06:01 AM

The following seems to work:

Code:

Dim bsize As Long = 1128532467868.12
Dim size As String = Format(bsize, "#,###")
MessageBox.Show(size)

eelisMX · January 27th, 2005, 06:38 AM

Thanks for the quick reply.

It works during debugging, but when I write the number to log file it still apears with the question mark (in the seperator place). kind of strange since the other formatted number is written to the file on the same time and is ok.

jaucourt · January 27th, 2005, 08:52 AM

I've tried the following:

Code:

        Dim bsize As Double = 1128532467868.12
        Dim size As String = Format(bsize, "#,###")
        Dim e1 As New EventLog("Application")
        e1.Source = "AppTest"
        e1.WriteEntry(size)
        Dim sw As New System.IO.StreamWriter("C:\output.txt")
        sw.WriteLine(size)
        sw.Flush()
        sw.Close()

and the number appears ok in both the event log and in the output text file. How are you writing to the log file?

BrianWren · January 27th, 2005, 12:55 PM

What program are you using to view the resultant log file?

eelisMX · January 28th, 2005, 04:23 AM

Hi

Im writing using a StreamWriter and WriteLine just as you do in the example. The file is .log file and the text is appended every time its been open to write. I'm not using EventLog, rather send a string to the WriteLine method.

Code:

Dim writer = New StreamWriter(logFileName, True, System.Text.Encoding.ASCII)
writer.WriteLine("{0}", msg)
writer.Flush()
writer.Close()
writer = Nothing

Could it be because of the encoding?

At the moment I just open it with NotePad.

jaucourt · January 28th, 2005, 05:02 AM

Being that the encoding is the only thing that is different, I'd suggest that that is the case. Put it in unicode (just take off the final argument in your call to the constructor method of Steamwriter) and see if it's ok.

eelisMX · January 28th, 2005, 05:22 AM

Problem solved!!

It was indeed the Encoding.ASCII argument.

Thanks for your time!