R
And then keep price and quantity in an excel
Size: a a a
2021 April 08
R
Along with Total which is price *quantity
R
But it seems data which we extract from mail body is in string format
R
So how to read the data from email body and do calculation
R
e.g
R
Price#120
R
Quantity#3
R
In one email
R
Similarly
R
Price#134
R
Quantity #4
R
In other email
R
I need to read these values and maintain an excel sheet
R
Adding Total=price*quantity
R
Any suggestions
R
?
KH
Read mail body first
KH
Then extract doing string operation
dn
You can also use Regular Expression to accurately extract the required data from the mail body text.
R
I amble to extract ..it's automatically extracting in string format..I need the values in number format for calculations