I am a beginner and need your support for the below problem.
I get a string value from the mail subject as mentioned below. i need to split it and put it in a separate variables for processing further.
You paid Rs. 8 to Cosmo Juice And Cakes
In the above sentence the want “8” and “Cosmo Juice And Cakes” to be stored in Variables Amount and Vendor.
I’m thinking of using split function.I want to store the value before “to” in Amount variable and after “to” in Vendor variable.
Can someone suggest me,how can i do this?