Power Query in excel 2016 issue importing text firl

[Cobrien]

I'm trying to create a new connection and import a text file so I can work with power query.

I was expecting to see
File Origin Delimiter
1252: Western European (Windows) ~

but I only see

File Origin
1252: Western European (windows)

how can I get the delimiter box to show I have 40 columns of data separated with ~

Thanks in advance

 

[sandy666]

after import you should see something like this: image

 

[Cobrien]

after import you should see something like this: image

Yes Sandy

that what I expected to see but I see this:

https://onedrive.live.com/?cid=E4D6...653372!437&parId=E4D6DAC61C653372!111&o=OneUp

 

[sandy666]

your picture doesn't exist
your steps are: Data - New Query - From File - (choose proper) - Import?

 

[Cobrien]

https://imgur.com/a/PDUbDwXI don't get delimiter

 

[sandy666]

try this way:
file_name.txt change extension to file_name.csv
or simply add extension: file_name.txt.csv
then try import again

btw.don't open your txt file just change extension

 

[Cobrien]

try this way:
file_name.txt change extension to file_name.csv
or simply add extension: file_name.txt.csv
then try import again

btw.don't open your txt file just change extension

Thank Sandy

That did the trick.

 

[sandy666]

You are welcome
per ardua ad astra

have a nice day