Finding the alphabets from a Alphanumeric in OTBI.
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.
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):