Search in column.

koolsun85 · Post by **koolsun85** » Tue Apr 19, 2011 6:17 pm

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.

ray.wurlod · Post by **ray.wurlod** » Tue Apr 19, 2011 6:51 pm

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)) = ""

koolsun85 · Post by **koolsun85** » Tue Apr 19, 2011 7:19 pm

I couldn't see the full content. Can you allow to watch the premium content.

ray.wurlod · Post by **ray.wurlod** » Tue Apr 19, 2011 8:43 pm

Certainly. Check this link for details.

koolsun85 · Post by **koolsun85** » Wed Apr 20, 2011 12:53 pm

Thanks a lot ray. It worked.