Register Login

Create Custom Function in BODS

Updated May 18, 2018

How to Create Custom Function in BODS?


I'm a newbie to Data Services and want to create a custom function for to check for special characters in a string. But I'm having difficulties to come up with the design, can someone please guide me in the right direction?


  • 05 Dec 2017 5:44 pm Sonia Barwar Helpful Answer

    Please follow the steps below in order to create custom functions for checking special characters in a string:

    1. First, open the designer and then navigate to Tools -> Custom Functions from the top level menu.
    2. Now in the window, please right-click the area with the list of functions and then choose New.
    3. Please choose the name of the new match_regex function and fill the description section.
    4. Now at last click on next in order to open the Smart Editor window and execute the following code below:

    $Len = length( $InputParameter );
    $Check = match_regex( $InputParameter , '[alnum]{' || $Len || '}' , 'CASE_INSENSITIVE' );
    Return $Check