Get Data from txt file with multiple delimiters

AllisterB · April 11, 2022, 4:43am

Hi

In Excel I am Getting data from a txt file. When I use Get Data I get the data in one column. i think this is because there are multiple delimiters.

How do i dynamically deal with a variety of delimiters in a txt file so that I get the data in table?

Thanks

Allister

Melissa · April 11, 2022, 11:52am

My first impression is that you could be dealing with a fixed width format, not delimited data.
Explore this video if that’s the case

I hope this is helpful

jafernandezpuga · April 11, 2022, 12:02pm

Hi @AllisterB,
To get to the solution for this example file, it helped me to open the file in the Notepad++ application and show all the characters:

The dots are spaces and the arrows of different sizes are tabs.

AllisterB · April 12, 2022, 10:24am

This tutorial was so good - I learnt heaps - thank You

AllisterB · April 12, 2022, 10:25am

This was helpful - thank You

Your post got me thinking along theright lines.