how to extract currency from a string of text
similar to a bank statement
07-22 Point Of Sale Withdrawal MARTYS FI 61 MAIN 13.99 - SHOPKINTON MAUS
07-22 Point Of Sale Withdrawal PAN THAI 44.38 - RESTAURANTHOPKINTON MAUS
07-22 Point Of Sale Withdrawal ALS STATE STREET 10.00 - CABOSTON MAUS
07-22 External Deposit Resilience03WBZk C:42320H:03WBZk - 35.00 DIR DEP
I want to be able to extract the bold numbers nnnn.nn
Bruce Johnson
Director Portfolio, Project Methods & Governance
Veolia North America
Boston, MA
Answers
-
This may need to be a manual process unless you (hopefully) have a slight typo on the last entry where the amount comes after the hyphen as opposed to before the hyphen as it is in the other entries.
If it is not a typo, will that only ever happen when the last bit is "DIR DEP"?
Basically... We need to find some kind of logic that is the same across every entry of similar type (such as POS vs Dir Dep) or across every entry regardless of type (this would be ideal).
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- 10.7K Get Help
- 63 Global Discussions
- 68 Industry Talk
- 385 Announcements
- 3.5K Ideas & Feature Requests
- 55 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives
Check out the Formula Handbook template!