Forum Discussion
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", [ ...
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"
]
]