Forum Discussion

Data_Scientist's avatar
Data_Scientist
Copper Contributor
Apr 28, 2020

incorrect import of text column

Hi,

 

formerly the value '01.100' in a  text-file was imported correctly & automatically in a xls-file with the same format ( 01.100 as text )

Since updates of MS 365 a few weeks ago, the value is imported as an integer-field with the value 1.100. 

 

How can I avoid this without using the text import wizard ?

 

thanks

 

excel

4 Replies

  • Lewis-H's avatar
    Lewis-H
    Iron Contributor
    Apr 30, 2020
    To make the columns be imported successfully, you may need to replace the slash “\” with “,” and save the text file as a .csv file as a workaround. When importing it , select Comma.

    Meanwhile, I also suggest you click on File>Feedback>Send a Frown to report the issue in From Text/CSV to our related team so that they will be aware of the issue for further investigation.
  • Wyn Hopkins's avatar
    Wyn Hopkins
    MVP
    Apr 29, 2020

    Hi Data_Scientist 

     

    What method are you currently using to import the text file?

     

    Are you using Power Query?

     

    Hope that helps

     

    Wyn

    MVP

    Australia UTC+ 8

     

     

     

     

     

     

    • Data_Scientist's avatar
      Data_Scientist
      Copper Contributor
      Apr 29, 2020

      Hi Wyn Hopkins 

       

      This is a simple text-file , saved with extension .xls.

      After saving, we can open the file without any actions and  all Field formats are ok at once.

       

      so, we don't use the Power query to finish importing.

       

      thks

       

      • Wyn Hopkins's avatar
        Wyn Hopkins
        MVP
        Apr 30, 2020

        Hi Data_Scientist 

         

        My approach would be to leave the file as a .txt file then use  Power Query to import it and specify the column types in Power Query

         

         

        Wyn

Resources