1. Attachments are working again! Check out this thread for more details and to report any other bugs.

What to use when "," can not be in a large number?

Discussion in 'Fred's House of Pancakes' started by bwilson4web, Jun 8, 2014.

  1. bwilson4web

    bwilson4web BMW i3 and Model 3

    Joined:
    Nov 25, 2005
    27,068
    15,372
    0
    Location:
    Huntsville AL
    Vehicle:
    2017 Prius Prime
    Model:
    Prime Plus


    I'm running into a problem with tables that uses "|" and "," to separate columns. But sometimes we want to display numbers to give a clue as to the size:
    1
    10
    100
    1,000
    10,000
    100,000
    1,000,000

    For example:
    100000 1000000
    100,000 1,000,000

    Both lines have the same numbers but the second one is much easier to tell the relative sizes.

    Candidates for one thousand (10**3) separators:
    1000 - nothing
    1.000 - period, ambiguous with fraction
    1 000 - blank, ambiguous with another number
    1;000 - semicolon
    1:000 - colon
    1`000 - reverse apostrophe
    1'000 - forward apostraphe

    Any thoughts?

    Bob Wilson
     
  2. Mendel Leisk

    Mendel Leisk Senior Member

    Joined:
    Oct 17, 2010
    54,474
    38,106
    80
    Location:
    Greater Vancouver, British Columbia, Canada
    Vehicle:
    2010 Prius
    Model:
    Touring
    Is this in Excel?
     
  3. KhaPhoRa

    KhaPhoRa Member

    Joined:
    Feb 7, 2013
    168
    37
    0
    Vehicle:
    2006 Prius
    Model:
    II
    If it's just a "what do you prefer" question then I like the simple forward apostrophe. It does the job nicely.
     
  4. Bill the Engineer

    Bill the Engineer Senior Member

    Joined:
    Jun 6, 2013
    1,044
    2,272
    467
    Location:
    At the beach in Delaware...
    Vehicle:
    2010 Prius
    Model:
    IV
    1000 = 1K
    10,000 = 10K
    1,000,000 = 1M
    etcetera, etcetera, etcetera,...

    Bill the Engineer
     
  5. ETC(SS)

    ETC(SS) The OTHER One Percenter.....

    Joined:
    Oct 28, 2010
    7,668
    6,483
    0
    Location:
    Redneck Riviera (Gulf South)
    Vehicle:
    Other Non-Hybrid
    Model:
    N/A
    Can you just use a space?
    1
    10
    100
    1 000
    10 000
    100 000
     
  6. Easy Rider

    Easy Rider Active Member

    Joined:
    Feb 9, 2014
    982
    210
    0
    Location:
    N. Central Florida
    Vehicle:
    2013 Prius c
    Model:
    Three
    Are you programming in a 50 year old version of Cobol or Dbase ??
    Upgrade your software.
     
  7. Bill the Engineer

    Bill the Engineer Senior Member

    Joined:
    Jun 6, 2013
    1,044
    2,272
    467
    Location:
    At the beach in Delaware...
    Vehicle:
    2010 Prius
    Model:
    IV
    I prefer FORTRAN myself. BASIC was just too... Basic.

    Bill the Engineer
     
  8. SageBrush

    SageBrush Senior Member

    Joined:
    Jun 4, 2008
    11,627
    2,530
    8
    Location:
    Southwest Colorado
    Vehicle:
    2012 Prius v wagon
    Model:
    Two
    Is the formatting HTML ?
    Lots of (most?) languages have an 'escape' character, meaning the subsequent character is treated as a literal rather than a command.
     
  9. bwilson4web

    bwilson4web BMW i3 and Model 3

    Joined:
    Nov 25, 2005
    27,068
    15,372
    0
    Location:
    Huntsville AL
    Vehicle:
    2017 Prius Prime
    Model:
    Prime Plus


    The software is XenForo and the tables are what we have. Still, we have a winner:

    1'000'000
    10'000'000

    It is in effect a comma on the top.

    There is no ambiguity as it is typically used with angular notation, degrees, minutes, and seconds or to indicate feet. The three digits on the right are not found in angular notation or feet. Here is an example:

    Year Diesel car SUV Hybrid car SUV
    1 2013
    833'324​
    2'821'599​
    2 2012
    796'794​
    2'290'903​
    3 2011
    709'147​
    1'945'295​
    4 2010
    640'779​
    1'714'966​
    5
    6 2013-12
    +36'530​
    +530'696​
    7 %+/-
    +4.58%​
    +23.17%​
    8
    9 2013-10
    +192'545​
    +1'106'633​
    10 %+/-
    +30.05%​
    +64.53%​


    Bob Wilson
     
    #9 bwilson4web, Jun 8, 2014
    Last edited: Jun 9, 2014
  10. SageBrush

    SageBrush Senior Member

    Joined:
    Jun 4, 2008
    11,627
    2,530
    8
    Location:
    Southwest Colorado
    Vehicle:
    2012 Prius v wagon
    Model:
    Two
    That would not be my preference, but at most I am one vote :whistle:
    1 000 000 seems easier to read

    A quick google suggests that a backslash is the escape character
     
  11. bwilson4web

    bwilson4web BMW i3 and Model 3

    Joined:
    Nov 25, 2005
    27,068
    15,372
    0
    Location:
    Huntsville AL
    Vehicle:
    2017 Prius Prime
    Model:
    Prime Plus
    Sad to say but " " is well overloaded. If I or anyone else needed to take out the separator, a SPACE causes a lot of grief.

    It works in some languages but not in the table software we have available. An escape character would be nice.

    Bob Wilson