Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Validate account format in DRM

Anna BalzakFeb 4 2019 — edited Feb 20 2019

I need validation of the format for a new account entered by users. The format should be xxx_xxxxxx where X is numeric. For example 123_456789.

I found Format function in DRM list of functions.

Format(Format,ParamType,ValueToFormat)

I did not know how to specify format I need users to enter. I found an example on one of the Java sites and wrote the following code for my validation

IF(Format("[0-9]{3}_[0-9]{6}$",integer,PropValue(Core.Abbrev)),False,True)

Unfortunately, it returns true if format is correct or not.

Any help would be appreciated.
This post has been answered by Dharmaraj Borse on Feb 18 2019
Jump to Answer
Comments
Post Details
Added on Feb 4 2019
#business-intelligence-applications, #hyperion-drm-analytical-master-data, #system-management-and-integration
8 comments
504 views