Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
Finding the alphabets from a Alphanumeric in OTBI. — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Finding the alphabets from a Alphanumeric in OTBI.

Received Response
edited Mar 2, 2023 1:37PM in General Transactional Reporting (OTBI) 2 comments

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):

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!