@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 | 2321 | February 27, 2023 | |
| Only show substring of the column? | 4 | 79 | May 22, 2024 | |
| Eliminate the numeric characters in my string | 4 | 31 | October 24, 2024 | |
| How to use "like" wildcard operator in QS | 1 | 956 | June 27, 2024 | |
| Trim a data | 8 | 48 | August 18, 2025 |