Vista - Convert Bytes to Gigabytes

Hi, I have a VBscript which I want to read data from an XML file
produced by a backup application and post it into an excel spreedsheet
for reference. At the moment we just write down the value and type it
in, I want to automate this. I've got the script to pretty much work
appart from the values it gets are in bytes and thus not really very
meaninful.

Then script reads the bytes from the XML file and then I tried to
convert it to a double but it didn't like it because of the very large
number. As such is there a way that I can convert the string to
gigabytes before I made it into a double or int? This is driving me
insane as I can't find anything useful anywhere online Any help/
advice would be appreciated. All I need is a way to convert the bytes
I have read to Gigabytes to be added to an excel spreedsheet.

Thanks
Steve

On Jul 27, 6:55*am, SkySte <ste.is....@xxxxxx> wrote:Have you tried soemthing like this? ...

gbytes = Round(bytes / 1024^3, 3)

Tom Lavedas
***********

"SkySte" <ste.is.gr8@xxxxxx> wrote in message
news:bed01341-9ff4-4a30-8101-ec1f7838ba55@xxxxxxYou could lop off the three right-most characters in order to convert Bytes
to kBytes:
sCapacity = "1234567890"
if len(sCapacity) > 3 then skBytes = Left(sCapacity, Len(sCapacity) - 3)
if skBytes= "" then skBytes = 0

On Jul 27, 8:18*am, "Pegasus [MVP]" <n...@xxxxxx> wrote:That's not the way it works, since bytes are the actual count and
GigaBytes are a count of 1024^3 byte blocks (2^30 bytes). You can see
the effect of this distinction if you look at the Properties of a
drive and note the difference between the bytes and GB properties for
any of the capacity parameters listed in the dialog.

Tom Lavedas
***********
http://there.is.no.more/tglbatch/

That would produce a 7% larger number.

"Tom Lavedas" <tglbatch@xxxxxx> wrote in message
news:1a5b9a4d-e27d-4ab8-8f17-1123e466bb10@xxxxxx
On Jul 27, 8:18 am, "Pegasus [MVP]" <n...@xxxxxx> wrote:That's not the way it works, since bytes are the actual count and
GigaBytes are a count of 1024^3 byte blocks (2^30 bytes). You can see
the effect of this distinction if you look at the Properties of a
drive and note the difference between the bytes and GB properties for
any of the capacity parameters listed in the dialog.

Tom Lavedas
***********
http://there.is.no.more/tglbatch/

================

I'm quite aware of this difference. If it matters for the OP then it's a
trivial thing to make the appropriate adjustment after lopping off the three
trailing characters. With a little more effort he could even implement a
rounding function.

"whs" <guest@xxxxxx-email.com> wrote in message
news:1eeec82dc44b27bcb8fcd8b8fda4fa70@xxxxxx-gateway.com...7%? More like 2.4%! And as I said - the cure is trivial, well within reach
of a beginner in VB Script programming.

2.4% for Megabytes and 7% for Giga bytes. Multiply 1024x1024x1024 and see what the result is.

"whs" <guest@xxxxxx-email.com> wrote in message
news:5a2bf51e64d770cb0c17cf0c81f26981@xxxxxx-gateway.com...Please do not misquote me. I wrote "You could lop off the three right-most
characters in order to convert Bytes to kBytes". Your figure of 7% (7.37%)
applies to a triple conversion (Bytes to GBytes), which would be ridiculous
because the OP would lose most of the information he is after. A conversion
to kBytes is probably sufficient for his purpose, hence the uncompensated
error is 2.4%.

Pegasus [MVP] wrote:For some unknown reason, hard drive manufacturers seem to be oblivious to
the correct way to count BYTEs and have been getting away with it for years.
Perhaps they should be required to indicate their unit of measure is
actually characters and not BYTEs.

--
Todd Vargo
(Post questions to group only. Remove "z" to email personal messages)