We have records, that contain phone numbers in a single line text field. Filtering works, when using “contains”. But they are broken, when with use “ends with”.
Phone number ends with “5050”:
Does work:
- contains “5050”
- ends with “050”
- ends with “5050”
Doesn’t work:
- ends with “0”
- ends with “50”
Phone number ends with “5055”:
Does work:
- contains “5055”
- ends with “55”
- ends with “055”
- ends with “5055”
Doesn’t work:
- ends with “5”
Phone number ends with “5057”:
Does work:
- contains “5057”
- ends with “7”
- ends with “57”
- ends with “057”
- ends with “5057”