Announcement

Collapse
No announcement yet.

Data compare, Detected/Numeric broken float data

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Data compare, Detected/Numeric broken float data

    Code:
    PS D:\tmp> gc .\t1.csv
    data_double_1, data_double2
    1.230, 2.450
    
    PS D:\tmp> gc .\t2.csv
    data_double_1, data_double2
    1.23, 2.45

  • #2
    Hello,

    By default, this should detect and work as you expect. What are your current Windows Regional settings for Dates and Numbers? We grab our initial settings from here, and if you are in a region where "." is the thousands place modifier it would explain the behavior you are seeing.

    If you go to Tools menu -> File Formats, select your format (Comma Separated Values?), and in the Type tab, what is the "Decimal Symbol" currently set to?

    Also, are you using the latest version of BC3 (3.3.8)?
    Aaron P Scooter Software

    Comment


    • #3
      Windows Regional
      You nailed it!
      I have swedish Windows Regional settings, and in swedish we have , not . for dec symbol.

      But I'm working on a system with output in GB/US format.

      Changing the default works great, thanks alot for the quick help!

      Really great tool!

      Comment

      Working...
      X