Importing a text file in excel

Question

Hello I have a text file in this format below. I'm wondering how I can get each phrase in the quotations to be in its own column per [] block. Thank you in advance.ex.[&nbsp; &nbsp;"example",&nbsp; &nbsp;[&nbsp; &nbsp; &nbsp; "example",&nbsp; &nbsp; &nbsp; "example"&nbsp; &nbsp;]][&nbsp; &nbsp;"example",&nbsp; &nbsp;[&nbsp; &nbsp; &nbsp; "example",&nbsp; &nbsp; &nbsp; "example"&nbsp; &nbsp;]]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

peiyezhu · Answer

https://techcommunity.microsoft.com/t5/excel/how-to-use-power-query-to-parse-a-txt-file/m-p/3809580parse txt

sergeibaklan · Answer

JonathanP2105&nbsp;
Is that exact format, or you have another separators within file or at the beginning/end (e.g. {}, :, etc)?
If exact, you have nested blocks []. How many levels it could be and how columns shall look for such sample
[

"example1",

[

"example2",

"example3"

]

Forum Discussion

Importing a text file in excel

2 Replies

Resources