@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.
DeepakS
2
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| Extract numeric portion of a string | 4 | 2347 | February 27, 2023 | |
| Only show substring of the column? | 3 | 91 | May 16, 2024 | |
| Eliminate the numeric characters in my string | 4 | 45 | October 24, 2024 | |
| How to use "like" wildcard operator in QS | 1 | 1021 | June 27, 2024 | |
| Trim a data | 7 | 69 | August 18, 2025 |