06-09-2020 10:43 AM - edited 06-09-2020 10:52 AM
Is this a bug?
Intention: filter the string character based on whether or not its an 'alphabet' character.
Approach 1 (Loop 1): Using case structure with string characters as range ("A".."Z", "a".."z")
Issue: last characters in the specified range ("A".."Z", "a".."z"), which is "Z" and "z" are not included.
Solution 1 (Loop 2): Include next character in series so that required character is no longer the last character. Instead of "A".."Z" make is "A".."[" and instead of "a".."z" make it "a".."{"
Solution 2 (Loop 3): Include the last character ("Z" or "z") again.
The default case (in all case structures) contains a FALSE constant.
Lower two loops give me intended result (filter all characters other than alphabets).
Solved! Go to Solution.
06-09-2020
11:21 AM
- last edited on
12-20-2025
06:24 PM
by
Content Cleaner
No, that's the correct behavior for strings. The Help file for case structures links to this:
Numeric ranges are inclusive, but string ranges are not.
Try using Match Pattern instead:
06-09-2020
12:39 PM
- last edited on
12-20-2025
06:25 PM
by
Content Cleaner
06-09-2020 01:12 PM
We discuss the issue of string case structure ranges in my nugget post on string case structures.