IsRegEx - script and chart function

Overview

Open the Data load editor and add the load script below to a new tab.

The load script contains:

• A field, reg_exp, containing input strings that may or may not be valid regular expressions.

• Two calculated fields to check if each value in reg_exp is a valid regular expression or not:

  • validity_no_hint: Displays -1 (true) if the regex is valid, and 0 (false) if it is invalid.

  • validity_with_hint: Displays -1 (true) if the regex is valid. If the regex is invalid, an autogenerated error message outlines issues with the input, with possible hints to help fix it.

Load script

[Expression Validity]:
	Load
		*,
		IsRegEx(reg_exp) as validity_no_hint,
		IsRegEx(reg_exp,1) as validity_with_hint
		;
Load
*
Inline
`
reg_exp
[a-z]+
([a-z)(0-9)+
abcdefg|[0-7
\$|¢(0-9)
`;

Results

Load the data and open a sheet. Create a new table and add these fields as dimensions:

• reg_exp

• validity_no_hint

• validity_with_hint

Overview

Open the Data load editor and add the load script below to a new tab.

The load script contains:

• A field, reg_exp, containing input strings that may or may not be valid regular expressions. This field is contained in a table named Regular Expressions.

• A where clause that only loads records into the data model when the input is a valid regular expression.

Load script

[Regular Expressions]:

Load
*
Inline
`
reg_exp
[a-z]+
([a-z)(0-9)+
abcdefg|[0-7
\$|¢(0-9)
`
WHERE
IsRegEx(reg_exp)=True()
;

Results

Load the data and open a sheet. Create a new table and add this field as a dimension:

• reg_exp

[a-z]+ and \$|¢(0-9) are valid regular expressions, so they have been loaded into the data model. ([a-z)(0-9)+ and abcdefg|[0-7 are not valid regular expressions, so they are not loaded into the data model.

Overview

In this example, we load a set of input strings into the data model and add them to a table, along with two calculated dimensions which evaluate the validity of the regex. The two calculated dimensions convey the same information in different ways.

Open the Data load editor and add the following load script to a new section.

The load script contains a field, reg_exp, containing input strings that may or may not be valid regular expressions. This field is contained in a table named Regular Expressions.

Load script

[Regular Expressions]:

Load
*
Inline
`
reg_exp
[a-z]+
([a-z)(0-9)+
abcdefg|[0-7
\$|¢(0-9)
`;

Results

Do the following:

1. Load the data and open a sheet. Create a new table. Add reg_exp as a dimension .

2. Next, add the following calculated dimension:

   =IsRegEx(reg_exp)

   This is a basic chart expression that shows -1 (true) if the input is a valid regular expression, and 0 (false) if it is not.

3. Add another calculated dimension:

   =if(IsRegEx(reg_exp), 'Valid regex', 'Invalid regex')

   This is a conditional expression that offers more detail into the validity of the input.