Forum Discussion

anupambit1797's avatar
anupambit1797
Steel Contributor
Jun 02, 2025
Solved

Text extract

Dear Experts,                     I am attaching a txt file ( dump file/source) from where I need to get the data like in the below format:- Any PQ, or legacy formulas would be of great help! i...
  • SergeiBaklan's avatar
    Jun 03, 2025

    With Power Query it gives

    but I'm not sure I understood the logic correctly. Source is the stream of text lines without proper start and end.

    Query itself definitely could be optimised.

Resources