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.
Hi everybody,
Here is my problem :
I'm trying to import a txt file :
let
Source = Csv.Document(File.Contents("Z:\xxxx.txt"),[Delimiter=" ", Column=120, Encoding=1252]),
the delimiter is a tab and I have 120 columns, perfect. but the string fields in my txt file have quotes, exemple : 'Dupond'
What can I do to have only Dupond in my table ... without the quote ?
Thank you
Stéphane
You could add a step where you replace the single quotes with nothing. Transform | Replace Values, ', [nothing]
Yes I found this option ...
but is there an option (as in Microsoft Query) to indicate that the text is surrounded by quote ?
in the help of csv.document there talk about QuoteStyle.Csv ... but I don't know if it this appropriate, and how to use it ...
@StefTheo - I looked through the documentation here for Csv.Document
https://msdn.microsoft.com/en-us/library/mt260840.aspx
I didn't see an option for setting QuoteStyle, but I do see the remark. I believe that the remark is simply telling you that it is going to use double quotes as delimiters. I have not been able to find any way of changing the quote style. When using the Excel data import (not Power Query), you have the option of setting that, but I don't believe it is using the same engine under the hood.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.