How to Extract a Substring of a Specified Format from a String
Problem description & analysis
Below is an Excel file book1.xlsx:
We are trying to extract numbers from each of column B’s strings, and get the first one to enter into column E. The expected result is as follows:
Solution & explanation
Load add-in ExcelRaq.xll in Excel, and
Enter the following formula in cell E2: =esproc("=?.words@d()(1)",B2). Enter similar formulas in the other cells to get results.
https://stackoverflow.com/questions/63775486/how-to-extract-specific-text-from-a-field-in-excel
SPL Official Website 👉 http://www.scudata.com
SPL Feedback and Help 👉 https://www.reddit.com/r/esProc
SPL Learning Material 👉 http://c.scudata.com
SPL Source Code and Package 👉 https://github.com/SPLWare/esProc
Discord 👉 https://discord.gg/ydhVnFH9
Youtube 👉 https://www.youtube.com/@esProc_SPL