What is a good way to parse pdf into excel? It needs to be flexible, perhaps working from copied data from the pdf. Thanks for any help

With Power Query ABC1DateAmountDescription210/31/2023$11.61Sakuramobairu31,100.00 JPY Rate:0.010554411/2/2023$83.23Holiday Inn Santiago A Santiago547,016.00 CLP Rate:0.001770611/2/2023$25.77Whittakers728.03 NZD Rate:0.919372811/2/2023$20.23Vantage Bar922.00 NZD Rate:0.9195451011/9/2023$16.06Refugio Dickson Vertic Pto. Natales119,326.00 CLP Rate:0.001722121314DateAmountNew Description1510/31/202311.61Sakuramobairu 1,100.00 JPY Rate:0.0105541611/2/202383.23Holiday Inn Santiago A Santiago 47,016.00 CLP Rate:0.0017701711/2/202325.77Whittakers 28.03 NZD Rate:0.9193721811/2/202320.23Vantage Bar 22.00 NZD Rate:0.9195451911/9/202316.06Refugio Dickson Vertic Pto. Natales 9,326.00 CLP Rate:0.001722 let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], #"Changed Type" = Table.TransformColumnTypes(Source,{{"Date", type date}, {"Amount", Currency.Type}}), #"Filled Down" = Table.FillDown(#"Changed Type",{"Date"}), #"Added Custom" = Table.AddColumn(#"Filled Down", "Custom", each if [Amount]= null then [Description] else null), #"Filled Up" = Table.FillUp(#"Added Custom",{"Custom"}), #"Filtered Rows" = Table.SelectRows(#"Filled Up", each ([Amount] <> null)), #"Merged Columns" = Table.CombineColumns(#"Filtered Rows",{"Description", "Custom"},Combiner.CombineTextByDelimiter(" ", QuoteStyle.None),"New Description") in #"Merged Columns"

Post in thread 'Parsing pdf into excel'

Is it possible to give me an example or a suggestion how this can be done

Parsing pdf into excel

B

Question

Printing Excel Tabs to Adobe PDF

Replies: 2

Views: 112

Apr 4, 2024

boonwd

B

J

Question

Not an Excel Q but thought post here.

Replies: 4

Views: 299

Sep 14, 2023

jbhakta

J

Solved

Save outlook attachment without file extensions

Replies: 3

Views: 499

Aug 23, 2023

johnnyL

J

Question

HOW TO DELETE NUMEROUS TEXT BOXES IN WORD BUT LEAVE TEXT INTACT

Replies: 0

Views: 320

Aug 24, 2023

JuicyMusic

J

A

Question

I need Outlook VBA to sendkeys to an open doc in Acrobat Reader....

Replies: 4

Views: 1K

Mar 29, 2023

Dan_W

D

Parsing pdf into excel

GScott

New Member

alansidman

Well-known Member

Excel Facts

GScott

New Member

alansidman

Well-known Member

Similar threads

Forum statistics

Share this page

Parsing pdf into excel

GScott

New Member

alansidman

Well-known Member

Excel Facts

GScott

New Member

alansidman

Well-known Member

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock