Create Custom Function in BODS

Updated May 18, 2018

How to Create Custom Function in BODS?

Hi,

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?

Comments

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