July 16, 2010
Hi Vanessa,
I suspect the problem lies in the different file formats being merged. Please check that the line containing Csv.Document specifies the delimiter type e.g.:
Csv.Document(File.Contents("C:\filepath\filename.txt"),[Delimiter=",",Encoding=1252])
If that's not the problem then I'll need to sample files so I can replicate the problem.
Mynda
P.S. the gif image was very difficult to read. Next time maybe try a .png or .jpg
Answers Post
September 13, 2016
Hello Mynda,
I have numbers on a sheet that I am trying to search from in a group of TXT files that are pipe delimited. I have a connection only to the txt files. Once I create a custom column (using =Csv.Document([Content]) I then Insert a split column by delimiter. I still get the error message when I expand table in new column.
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
November 8, 2013
Hi Vanessa,
Csv.Document([Content]) will automatically split by comma, most probably in the expand table dialog window you see more than 1 column.
Add a column with this formula instead:
= Table.FromColumns({Lines.FromBinary(File.Contents([Folder Path]&[Name]))
Should work better than Csv.Document, when you expand the table, you should have only one column, that you can split by pipe delimiter.
1 Guest(s)