Forum Discussion

anupambit1797's avatar
anupambit1797
Iron Contributor
May 01, 2023

How to use Power Query to parse a txt file

Dear Experts,

                      How to parse a txt file , into excel using Power query for the attached example

 

 

 

 

For example in above , I want to parse all the messages into excel , tried to use Power-Query

 

but not sure what to do as next step.. or by any other methods also if this is possible( Except VBA/Coding)

 

Many Thanks

Br,

Anupam

 

 

13 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor

    anupambit1797 

    What do you mean under "messages" and which headers you'd like to keep? Perhaps you may share sample file with the same information on screenshot.

Resources