Insert Table.ReplaceValue, before files from folder, have been split into columns?

[mmace1]

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? 

[AntrikshSharma]

@mmace1 Can't replicate the issue, works fine for me with double quotes in PDF.

[mmace1]

@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-u1w 

[AntrikshSharma]

@mmace1 Link has expired 🙁

[mmace1]

d'oh

https://www.dropbox.com/scl/fi/5u5cwa90kpvgmr1yzpc4b/Invoice-with-Double-Quotes.PDF?rlkey=smt1x6qdx9... 

[AntrikshSharma]

@mmace1 Share sample data with the final result

[mmace1]

@AntrikshSharma 

Here's how I'm combining PDF files from a folder

If 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)