Forum Discussion

zerratriani's avatar
zerratriani
Copper Contributor
Aug 16, 2023
Solved

How to extract unstructured data into excel

So I have data taken from a website and want to process it using Excel but I only have a .txt file. Here is the data like this. I've tried using the WRAPPROWS function but that doesn't work. Any sugg...
excel
Formulas and Functions
  • Lorenzo's avatar
    Lorenzo
    Aug 25, 2023

    zerratriani 

     

    Challenge is sometimes a Problem record consists of 6 rows, sometimes 7
    In attached file a Power Query approach. In the Source step replace the file path (line File.Contents) to the text file with yours:

     

        Source = Csv.Document(
        File.Contents("X:\Abc\Def\ProblemsSample.txt"),
        [Delimiter="#(lf)", Columns=1, QuoteStyle=QuoteStyle.None]
    )

     

zerratriani's avatar
zerratriani
Copper Contributor
Sep 04, 2023

I have an additional question, what if the data has one additional column? I tried to change the existing script, but it gave an error. Can you help me?

Resources