March 18, 2013 at 3:18 am
HI All,
Can anyone help me in skipping the special characters in the Result set. column value
For ex.
If the actual value fetched from DB is 12AV$BJ_
When it displays in Report , i want the output as 12AVBJ
Is it possible. I want only textbox value to be changed. Not any other.
Textbox should accept only alphanumeric values.
Is there any option to set such validation
Thanks,
March 19, 2013 at 6:57 am
You should be able to incorporate a Regex function to do this. Here is a sample:
•The Regex functions from the .NET Framework System.Text.RegularExpressions are useful for changing the format of existing strings, for example, formatting a telephone number. The following expression uses the Replace function to change the format of a ten-digit telephone number in a field from "nnn-nnn-nnnn" to "(nnn) nnn-nnnn":
=System.Text.RegularExpressions.Regex.Replace(Fields!Phone.Value, "(\d{3})[ -.]*(\d{3})[ -.]*(\d{4})", "($1) $2-$3")
I'm not a regular regex user, so I don't immediately know what your regex pattern would be, but you can go to a site like regexlib.com to get the pattern you need.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply