@CWong please refer this post Extract numeric portion of a string to check if it can help you with extracting numeric part of the string value.
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| Extract numeric portion of a string | 4 | 2306 | February 27, 2023 | |
| Only show substring of the column? | 4 | 77 | May 22, 2024 | |
| Eliminate the numeric characters in my string | 4 | 25 | October 24, 2024 | |
| How to use "like" wildcard operator in QS | 1 | 915 | June 27, 2024 | |
| Trim a data | 8 | 41 | August 18, 2025 |