There is a situation where i need to allow only alpha, numeric and a hyphen in a particular column . If i found out any other character i have to reject the entire record.
how to acheive this.. Need help on this.
Search in column.
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Use a constraint experession using Convert() function to detect the existence of any other characters. Something like the following would suffice:
Code: Select all
Convert("0123456789-ABCDEFGHIJKLMNOPQRSTUVWXYZ", "", UpCase(InLink.TheString)) = ""
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Certainly. Check this link for details.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.