Forum Discussion

Gjakovasc's avatar
Gjakovasc
New Member
4 years ago
Solved

Issue with Type Conversion and CSV?

I've got some trouble with type conversion. CSV flat contains column named rocket cost and it is written in format 50.0 or 75.0 or 1,130.0 etc. So it is clearly english format, where , is thousand se...
  • RayWu's avatar
    4 years ago

    Gjakovasc 
    There's culture applied
    1. on import, in power query. If not specified it defaults to the current system
    2. after importing the value there's a display culture that doesn't have to mutate the underlying data type. Like date-times are integers/floats under the hood, but you can set them to display in any text format.


    You can use the optional culture parameter set to en-US Which tells it use that locale/culture's rules for converting text to numbers.

     

       #"Numbers from en-US" = Table.TransformColumns(
            Source,
            {
                {"Number", each Number.FromText(_, "en-US"), type number}
            }
        ),

     

     

    hopefully this solve the problem.