Extracting data from a cell that contains transactions

[djpravah]

Hi Excellent Excellers ,

Help Required: How do I extract data from transaction SMS received from Banks on card swipe, each bank has a different format, for the below use cases:

1. Transaction SMS: I would like to extract the Amount and SHOP add them into two different cells
2. Monthly Statement SMS: I would like to extract the Bank Card, Total amt due, Due date into three different cells

Book1
	A	B
1	Transaction SMS	Statement SMS
2	Alert! INR 101.00 spent on yourXX Bank Credit Card xx at SHOP CHARLIE	Alert! Your Bank Card statement is here for XX 2023 Total amt due: INR 2500.32 Payment due date: 02 XXX 2023
3	INR 2,499.00 spent on Bank Card XX at SHOP BRAVO	Dear Customer, statement for Bank Card XX . Total amount of Rs 2500.87 is due by 05-XXX-23.
4	Alert: You've spent INR 250.00 on your XX card ** at SHOP ALPHA	Dear Customer, your statement for Card **** has been generated. /total payment Rs.XX,XXX.XX is due by DD/MM/YY.
5	Transaction Successful! INR 2514.09 spent on your Bank Card ending XX at SHOP DELTA	The e-Statement for your Bank Credit Card XX has been generated. Due Date: DD-MM-YYYY Total Due: Rs. X,XXX.XX
6	You've spent Rs.1016 On Bank Card xx At SHOP ECHO	Bank Credit Card XX Statement: Total due amt: Rs.XX,XXX.00 Due by:DD-MM-2023
Sheet1

Thank you in advance

 

[Herakles]

Anything is possible.

Are you provided with the name of the bank for each line?

Is the amount always preceded by the currency abbreviation?

 

[djpravah]

Anything is possible.

Are you provided with the name of the bank for each line?

Is the amount always preceded by the currency abbreviation?

Yes, bank name is provided the currency format is erratic in the last row it's Rs. 1,297.50 where as others have inr

 

[djpravah]

Could someone help with my query please

 

[djpravah]

Bumping up this, any guidance is greatly appreciated.

 

[Peter_SSs]

To enable helpers to consider possibilities:

• What are the expected results for that sample data or new sample data (post again with XL2BB please)?
  
  
• Explain the logic that would be used to obtain those results.