Solved

Converting 1000 to 1K

Posted on 2008-06-23
10
2,326 Views
Last Modified: 2013-12-16
Experts,

Any quick ideas how can i convert above 1000 values to number + K. 1000 to 1K or 10000 to 10K and so on ?
0
Comment
Question by:dotnetpro
10 Comments
 
LVL 18

Expert Comment

by:jcoehoorn
ID: 21846808
How would you want numbers like 1234 to look?  Do you need to convert 1000000 to 1M?  1000000000 to 1B?
0
 
LVL 6

Accepted Solution

by:
Bruce_1975 earned 65 total points
ID: 21846812
One possible solution:

Regards,
Bruce
public string ConvertNumber(int Number)
{
    if (Number >= 1000)
        return string.Concat(Number / 1000, "k");
    else
        return Number.ToString();
}

Open in new window

0
 
LVL 3

Expert Comment

by:darkmooink
ID: 21846819
i dont know how to do it in c# but here is the methodology
if n > 1000 then x=n/1000
result = x & "k"
0
DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

 
LVL 55

Expert Comment

by:Jaime Olivares
ID: 21846896
what about with megas?
0
 
LVL 18

Assisted Solution

by:jcoehoorn
jcoehoorn earned 60 total points
ID: 21846973
This should scale a little farther:

string GetKNotation(long value)
{
    string[] suffix = {"", "K","M", "B", "T"}; // what's after T?
    int power = 3;
    while (Math.Pow(10, power) < value)
        power++;
    power--; //was one greater than what we needed
 
    return (value / (long)Math.Pow(10, power)).ToString() + suffix[power/3];
}

Open in new window

0
 
LVL 18

Expert Comment

by:jcoehoorn
ID: 21847019
Arg, got ahead of myself.  In trying to optimize the power variable to skip a few iterations I broke it for very small numbers (<100).  This is better:
string GetKNotation(long value)
{
    string[] suffix = {"", "K","M", "B", "T"}; // what's after T?
    int power = 1;
    while (Math.Pow(10, power) < value)
        power++;
    power--; //was one greater than what we needed
 
    return (value / (long)Math.Pow(10, power)).ToString() + suffix[power/3];
}

Open in new window

0
 
LVL 6

Expert Comment

by:Bruce_1975
ID: 21847061
What comes next... http://en.wikipedia.org/wiki/SI_prefix

Regards,
Bruce
0
 
LVL 6

Expert Comment

by:Bruce_1975
ID: 21847074
and if you can't get enough of big (and small) numbers: http://en.wikipedia.org/wiki/Non-SI_unit_prefix

Regards,
Bruce
0
 
LVL 18

Expert Comment

by:jcoehoorn
ID: 21847099
Hehe, yeah I can find that page.  But if I followed that guide I would have used a G for Billion (Giga)  instead of a B.  The next up is either P for Peta or Q for Quadrillion, so there's still some confusion.  Since I used a B for Billion I should probably choose a Q, but then what would you use for Quintillion?
0
 
LVL 6

Expert Comment

by:Bruce_1975
ID: 21847767
Hi jcoehoorn,
there was a little mistake in your code. I fixed it and added the missing extensions.

Regards,
Bruce
string GetKNotation(long value)
{
    string[] suffix = {"", "k","M", "G", "T" , "P", "E", "Z", "Y"}; // what's after Y?
    int power = 0;
    while (Math.Pow(10, power) < value)
        power += 3;
    power -= 3; //was one greater than what we needed
 
    return (value / (long)Math.Pow(10, power)).ToString() + suffix[power/3];
}

Open in new window

0

Featured Post

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This document covers how to connect to SQL Server and browse its contents.  It is meant for those new to Visual Studio and/or working with Microsoft SQL Server.  It is not a guide to building SQL Server database connections in your code.  This is mo…
Many of us here at EE write code. Many of us write exceptional code; just as many of us write exception-prone code. As we all should know, exceptions are a mechanism for handling errors which are typically out of our control. From database errors, t…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question