Dear All,
We have a string which may be change in size between two specific constant strings we need to extract, how to do that;
Examples
1. Standard Purchase Order 2020234 for USD 1000.00 requires your approval.
2. Standard Purchase Order 20201001 for USD 15236.00 requires your approval.
3. Standard Purchase Order 202010 for USD 6.00 requires your approval.
as you can see string length between 'USD' and 'requires' changes. But we need to only extract:
1000.00
15236.00
6.00
may be it is simple questions, but sometimes you need a help to do it
How to do that?
Thanks and Regards,
Shareef