smoothlarryhughes
New member
- Local time
- Yesterday, 19:47
- Joined
- Jan 28, 2020
- Messages
- 2
Can anyone help me with an expression (preferably with built in functions) to pull the currency and dollar amounts out of the reference field? Examples below:
Reference | MONEY | CURRENCY |
/ACOM/43958,90EUR0,00 | 43958.90 | EUR |
/ACOM/48761,41USD0,00 | 48761.41 | USD |
/ACOM/1212,96USD0,00 | 1212.96 | USD |
/ACOM/702,89USD0,00 | 702.89 | USD |
/ACOM/222,50USD0,00 | 222.50 | USD |
/ACOM/6196,43EUR0,00 | 6196.43 | EUR |
/ACOM/208,16EUR0,00 | 208.16 | EUR |
/ACOM/7006,67EUR0,00 | 7006.67 | EUR |