Special Characters

  • 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,

  • 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