Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Possible bug importing fixed text in Power Query

Hello Guys


I have a simple fixed text file without separators:
fixed_text.PNG


The "double quote" character ( " ) in the text is to define "inches" here in Brazil.
If I use CsvDocument with fields sizes, it looks Power Query is getting lost because the Quote Char.

let
    Fonte = Csv.Document(File.Contents(filename), null, {0,8,30,40,50}, null, 65001)
in
    Fonte

 

fixed_imported.PNG

 

If I change double quote for single quote, the file is imported correct to the Power Query as is possible to see.

fixed_text2.PNG

 

Best Regards
Wanderlei Hüttel

Status: New
Comments
v-chuncz-msft
Community Support

@wanderlei 

 

Fields containing a line-break, double-quote or commas should be quoted in CSV file. Here you may open it as Text File and then select Split Column By Positions.

wanderlei
Regular Visitor

Hello @v-chuncz-msft 

Using Split Column By Positions works, but I don't want.
If I use the way I'm using, should have some option to ignore Quotes, because I'm using by position.
For this I said that it looks like a bug or something not foreseed