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.
Hello Guys
I have a simple fixed text file without separators:
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
If I change double quote for single quote, the file is imported correct to the Power Query as is possible to see.
Best Regards
Wanderlei Hüttel
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.