Forum Discussion
Insert Table.ReplaceValue, before files from folder, have been split into columns?
I have a folder of (PDF) files, that I'm importing tables from.
Some of the tables have double quotes, which causes Power Query to split things into an additional column.
I'd think I could do a Table.ReplaceValue(), to replace the double quotes, sometime before the Table.SplitColumn() that I assume is in there.
But when I check the Advanced settings for all the steps, I don't actually see Table.SplitColumn() anywhere
How can I get rid of the double quotes, before Power Query splits the table into columns? Or do I need to go about this a different way entirely?
6 Replies
mmace1 Can't replicate the issue, works fine for me with double quotes in PDF.
AntrikshSharma sorry, I missed that you couldn't replicate.
Below is a PDF file, that when Power Query injests, splits the column, due to double quotes:
https://send.vis.ee/download/b51526cf698308a6/#x_YCnPO-nqtsVT9P1b-u1wmmace1 Link has expired 🙁
mmace1 Share sample data with the final result
Here's how I'm combining PDF files from a folderIf the source file has "" in it, like below
Then when Power Query pulls in the file, it generates an extra column - Column2 below.
Instead it should....not do that, and just import the file as it does for tables that lack double quotes. e.g - correct:
If I were doing this manually - no problem, remove the extra column. But I'm importing a ton of tables from PDFs via the 'Import from Folder' functionality, and appending them. So, the columns need to line up.
I just need to either:
Get Power Query to replace, or ignore, those "" prior to the step where it decides how many columns there are
Or do some weird logic - like "If you do this operation and end up with 5 columns, delete column2)
