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