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 Daniel,

thanks!

However, this does not seem to be the whole code.

I cannot figure out what you mean with: "your code to import text files"

As I said, I am completely new to PQ and really would appreciate a complete working solution. I may learn along the way, but for now, I have no clue (and little time)  apart from what I learn from tutorial videos and I have not found one, which matches my problem.

 

I am using Excel2016 by the way.

 

Best,

Matthias

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

Hello, Matthiaskirsch . Try to replace "your code to import text files" with Lines.FromBinary(_) in the code provided by wdx223_Daniel 

  • 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