Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowTry your skills in the Power BI Dataviz World Championship! Round one ends June 26. Join now
Hi I tried to do the tutorial but I meet an issue with the folowing query which intend to split text to 5 columns.
= let
Source = Csv.Document(File.Contents("C:\Users\GD\Documents\POWER BI\Analyze CSV file\postprn\postprn.prn"),[Delimiter=":", Columns=2, Encoding=1252, QuoteStyle=QuoteStyle.None]),
#"Type modifié" = Table.TransformColumnTypes(Source,{{"Column1", type text}, {"Column2", type text}}),
#"Colonnes supprimées" = Table.RemoveColumns(#"Type modifié",{"Column2"}),
#”Fractionner la colonne par position” = Table.SplitColumn(Source,”Column1″,Splitter.SplitTextByPositions({0, 13, 32, 60, 74}, false),{“Account“, “Description”, “Language”, “Debit”, “Credit”}),
#"Type modifié1" = Table.TransformColumnTypes(#"Fractionner la colonne par position",{{"Column1.1", type text}, {"Column1.2", type text}})
in
#"Type modifié1"
I get the error:
Expression.SyntaxError : Jeton Identifier attendu. (Token identifier waited?)
What did I miss?
Thanks for your help
@GD61 at a glance, you are using the wrong quote character (needs to be the ascii ")
Hello,
I changed the quotes one by one, and that works.
How can I get the good quotes with my French version? What are there ASCII code?
Thanks
| User | Count |
|---|---|
| 24 | |
| 22 | |
| 22 | |
| 21 | |
| 13 |
| User | Count |
|---|---|
| 67 | |
| 56 | |
| 45 | |
| 42 | |
| 30 |