Finding the alphabets from a Alphanumeric in OTBI.

Mar 2, 2023 1:35PM

Summary: I have a requirement to identify the alphabets (be it upper/lower case) from a string. The format of the sting is as follows:

SSN: ****-XX-XXXX (112-10-1234)

TIN: XX-XXXXXXX (10-1234567)

The valid scenario is it should always be numeric. As the field is a free text, business can enter alphabets and special chars also. We need to list out all the invalid SSN/TINs in the report.

Any ideas would be appreciated. Thanks in advance.

Content (required):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):

Finding the alphabets from a Alphanumeric in OTBI.

Howdy, Stranger!