Forum Discussion
JonathanP2105
Oct 08, 2024Copper Contributor
Importing a text file in excel
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. [ "example", [ ...
peiyezhu
Oct 08, 2024Bronze Contributor
https://techcommunity.microsoft.com/t5/excel/how-to-use-power-query-to-parse-a-txt-file/m-p/3809580
parse txt
parse txt