Forum Discussion

thimremy's avatar
thimremy
Frequent Visitor
9 years ago
Solved

Problem to import the dot from a column

Hello,   One of the column I imported from my data source (CSV) is in Euro and has the following format when I open it via Excel:   FINAL_QUOTE 46.88 144.69 63.54 20.63 8.9 3...
Need Help
  • cs_skit's avatar
    cs_skit
    9 years ago

    You probably have non-english regional settings right?

    It happens for example when you have german CSV where delimiter is Semicolon but decimal seperator whould be comma but in your file its dot. Then he does not auto detect that.

     

    Solution is when using GET DATA Text/Csv in the following window on Data Type Detection select "Do not detect data types"

    then it is imported as text and you can change it in Query Editor.

cs_skit's avatar
cs_skit
Resolver IV
9 years ago

You probably have non-english regional settings right?

It happens for example when you have german CSV where delimiter is Semicolon but decimal seperator whould be comma but in your file its dot. Then he does not auto detect that.

 

Solution is when using GET DATA Text/Csv in the following window on Data Type Detection select "Do not detect data types"

then it is imported as text and you can change it in Query Editor.

  • thimremy's avatar
    thimremy
    Frequent Visitor
    9 years ago

    Hello cs_kit,

     

    Thanks for the piece of advise, it worked!

     

    Have a nice day,

     

    thimremy