Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2012

    Unanswered: Extracting Only Alphanumeric Charcater in DB2


    How can we extract only alpha numeric characters from a string in DB2??

    My input string is mixed with Special characters:
    Expected Ouput :
    ABCdef12343 YES
    (Only to extract Alpha numeric characters excluding the special characters)

    Note : Set of Special characters is not known exactly to use translate /replace function.

    Is it possible to use NOT function in inside translate/replace?
    (Like translate those characters to '' which does not belong to [A-Za-z0-9])

    Please help me in this .

    Thanks in advance.

  2. #2
    Join Date
    Jan 2004
    Croatia, Europe
    Provided Answers: 5
    You should have posted the question in DB2 forum; its functions might be different from Oracle ones.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts