Forum Discussion

Matthiaskirsch's avatar
Matthiaskirsch
New Member
2 years ago
Solved

Text files

Dear all,   being an absolute greehorn, I would appreciate getting instruction how to use Powerquery and the associateeditor for the following problem: I have a folder with .txt- files, each consi...
Tips and Tricks
  • AlienSx's avatar
    AlienSx
    2 years ago
    let
  Quelle = Folder.Files("C:\Users\kirsch\Desktop\text"),
  custom1 = Table.FromColumns(List.Transform(Quelle[Content], each Lines.FromBinary(_)),Quelle[Name])
in
  custom1
Matthiaskirsch's avatar
Matthiaskirsch
New Member
2 years ago

Hi AlienSx,

 

I guess I am just to dump. So this is what I see in the PQ-Editor:

let
Quelle = Folder.Files("C:\Users\kirsch\Desktop\text"),
custom1=Table.FromColumns(List.Transform(Quelle[Content],each "Lines.FromBinary(_) "),Quelle[Name])
in
custom1

 

Then I get the following error:

Expression.Error: Der Wert ""Lines.FromBinary(_) "" kann nicht in den Typ "List" konvertiert werden.
Details:
Value=Lines.FromBinary(_)
Type=Type

 

???

Best,

Matthias

 

AlienSx's avatar
AlienSx
Icon for Super User rankSuper User
2 years ago
let
  Quelle = Folder.Files("C:\Users\kirsch\Desktop\text"),
  custom1 = Table.FromColumns(List.Transform(Quelle[Content], each Lines.FromBinary(_)),Quelle[Name])
in
  custom1
  • Matthiaskirsch's avatar
    Matthiaskirsch
    New Member
    2 years ago

    Dear AlienSx,

     

    you are a genius. So simple and it works like a charm.

    Thank you so much, this will help me a lot and my generate some more questions in the future, now that I have seen that I get useful answers this quick.

    Best,

    Matthias

    • AlienSx's avatar
      AlienSx
      Icon for Super User rankSuper User
      2 years ago

      it's wdx223_Daniel who provided a solution to be honest. But thank you.