Forum Discussion

shaazrianlysis's avatar
shaazrianlysis
Regular Visitor
3 years ago

way to fix this auto converting?

hey, when i try to import data from a file with text and numbers - the power query changes the text into numbers and i dont know why... i hope you can help me with this ..... the NQ text changes...
Need Help
shaazrianlysis's avatar
shaazrianlysis
Regular Visitor
3 years ago

hey, thank for helping. the m-code:= Csv.Document(File.Contents("C:\chetrem\Short 1\User_Files\BackTesting_Read_files\ReadDataF3.txt"),[Delimiter=",", Columns=8, Encoding=1255, QuoteStyle=QuoteStyle.None])

it suppose to be for like 25 miliion row if thats matter

here is a few lines from the data:

NQ,09/01/2021 16:00:00,0,0,15634,15634.25,69935,15634.25
NQ,09/01/2021 16:00:01,0,0,15633.75,15634.25,69937,15633.75
NQ,09/01/2021 16:00:02,0,0,15633.5,15634,69946,15633.5
NQ,09/01/2021 16:00:03,0,0,15633.5,15633.75,69955,15633.5
NQ,09/01/2021 16:00:04,0,0,15633.5,15633.75,69957,15633.5
NQ,09/01/2021 16:00:05,0,0,15633,15633.5,69963,15633.5
NQ,09/01/2021 16:00:06,0,0,15632.75,15633.25,69970,15632.75
NQ,09/01/2021 16:00:07,0,0,15632.75,15633.25,69971,15632.75
NQ,09/01/2021 16:00:08,0,0,15632.75,15633.25,69971,15632.75
NQ,09/01/2021 16:00:09,0,0,15632,15632.5,69974,15632
NQ,09/01/2021 16:00:10,0,0,15632.25,15632.75,69978,15632.75
NQ,09/01/2021 16:00:11,0,0,15632,15632.5,69982,15632
NQ,09/01/2021 16:00:12,0,0,15632,15632.5,69982,15632

  • ronrsnfld's avatar
    ronrsnfld
    Icon for Super User rankSuper User
    3 years ago

    Still cannot reproduce the problem.

    Perhaps, since the file seems to be English and not Hebrew, changing the encoding to 1252 might help.

     

    But I doubt it, since the first two characters are `NQ` for each line (and not some unusual unicode equivalent), and I don't see how, after just the line of code you posted, they would change to different numeric values.

     

    Hopefully someone else will come along with an idea.