Getting table data from text file

Hi I am having a table data in a text data as below . I need to extract the Table items as i need to get the data from Item to subtotal and keep in excel . please help on it

DinoStorePleasesendpaymentsat
ACCOUNT:65575663784
IBAN:US99WER7269456
227CobblestoneRoad|30000Bedrock,NJSWIFT:BQWERROA324
PayPal:Test@paybil.com
INVOICE
IN-1577895544755
Client:
TOMTESTIssuedate:4/16/2020
222RockyWayNetdays:21
30000Bedrock,CobblestoneAveCurrency:USD
LAP.O.33/200-4
Item&DescriptionQuantityPriceLinetotal
FrozenBeans4100400.00
EnergyDrinks2170340.00
SUBTOTAL740.00
TAX10%74.00
TOTAL14.00
PayinvoicewithPayPal
I

Like this:

Processusvierge.zip (2,7 Ko)

Hi Anthony … Thanks for you response but here my requirement is just i need to get the bold values in the about text into a datatable . My approach is like can we get this by using string manipulations or regex ?

1 Like

Hey
So you want the bold values from Text??

Hi Pradeep … The bolded part is the table content and i need to extract it

1 Like

is it in excel or notepad??

Its a notepad file

is that from pdf??
if so you can use regex to extract the text!