Regex connector
With the Qlik RegEx Connector allows you to search or replace data using regular expressions from the Qlik Web Connectors RegEx Engine. In earlier versions of the Qlik Web Connectors, the RegEx Engine was accessible through the Sentiment and Text Analytics Connector.
Ways to Access Data
The RegEx Engine is part of the Qlik Web Connectors. You do not need to authenticate this connector to use it.
Load data from tables
You can use the following tables to select and load data:
SimpleMatch
Use this table to match data using regular expressions.
Replace
Use this table to replace data that matches regular expressions.
Use the Replace table to hide sensitive field data
Replace table takes a string, searches for a match based on the regular expression, and replaces the match with a new string. In the example below, the Message box contains a string of 13 digits. The Regular Expression field contains the regular expression that matches the first 9 digits of the message. The Replace Text field contains the string that will replace the first 9 digits when the connectors find a match. The Result table shows the new string after the connector has found a match.
The most effective way to use the RegEx Connector is to pass data from a table to the RegEx Connector to produce a new table with the connector results. The example script below loads a table from an xlsx file, passes rows of data to the RegEx Connector, and produces a new table.
When you load data with a script like above, you will see a table called RegexConnector_Replace that has two fields: map and Result. The original table used to pass data to the RegEx engine should not be available in Qlik Sense.