Forum

Importing text file...
 
Notifications
Clear all

Importing text files - delimiters not working

4 Posts
3 Users
0 Reactions
112 Views
(@michavard)
Posts: 3
Active Member
Topic starter
 

Hi,

I'm working through the Power Pivot course, and having trouble with lesson 3.06 - Importing text files.  Even though I've set a delimiter, the import brings in all the columns as a single field (i.e., the delimiter does not seem to be working).  I tried the same exercise with another text file that is [|] delimited, with the same result.  Help!

 
Posted : 18/04/2017 1:18 pm
(@mynda)
Posts: 4761
Member Admin
 

Hi Michelle,

With the pp_3_returns.txt file did you choose the 'Tab' column separator in the 'Table Import Wizard'?

If you're still having problems with this delimiter please provide more information:

  • What version of Excel are you using?
  • Please provide a screenshot of the Table Import Wizard screen and the other file you tried so I can text on my PC.

Thanks,

Mynda

 
Posted : 18/04/2017 8:05 pm
(@geoffm)
Posts: 4
Active Member
 

Hi

I have the same problem! The text file has a comma between the two elements. The raw file each row is contained between double quotes at the start and finish. I've tried all the delimiters without success.

I'm using Microsoft 365 with automatic updates.

A screen print is attached.

Geoff

 
Posted : 26/05/2023 8:28 am
(@geoffm)
Posts: 4
Active Member
 

OK just discovered the .csv note under the video!!! Will try that! Thank you! Geoff.

 
Posted : 26/05/2023 8:36 am
Share: