KeepChar - 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 dataset which is loaded into a data table called Example.

• The following fields in the data table:

  • InputText which contains the original text string to be processed.

  • CharsToKeep which contains the list of characters to retain from the original text string after processing.

Load script

Example:
Load * inline [
InputText, CharsToKeep
'a1b2c3', '123'
'a^b^c', 'abc'
'A^b^c', 'abc'
];

Results

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

• InputText

• CharsToKeep

Create the following calculated dimension:

• =KeepChar(InputText, CharsToKeep), to calculate the characters in InputText that match the characters in CharsToKeep.

The KeepChar(InputText, CharsToKeep) column returns only those characters in InputText that exactly match the characters in CharsToKeep. For example, the third row returns bc as those are the only characters in InputText that match the characters in CharsToKeep. The uppercase character A is not returned as the items in CharsToKeep are only lowercase.

The following code shows how to use the function in a load script.

Example:
Load
*,
keepchar(String1, String2) as KeepChar;
Load * inline [
String1, String2
'a1b2c3', '123'
];

Overview

This example uses the function to parse unstructured text (letters, numbers, and symbol characters) and deliver a structured output that retains only numerical characters.

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

The load script contains:

• A dataset which is loaded into a data table called Example.

• The following fields in the data table:

  • InputText which contains the original text string to be processed.

  • CharsToKeep which contains the list of characters to retain from the original text string after processing.

Load script

Example:
Load * inline [
InputText, InputCategory, CharsToKeep
'The numeric code for input processing is 123-456|789.', 'Code', '0123456789'
'Delivery of batch number: 333*456789.', 'Batch', '0123456789'
'Find the goods received in bay 16a', 'Bay', '0123456789'
];

Results

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

• InputText

• CharsToKeep

Create the following calculated dimension:

• =KeepChar(InputText, CharsToKeep), to calculate the characters in InputText that match the characters in CharsToKeep.

Compare the output of the KeepChar function to the original InputText string values that loaded in the script. The KeepChar function has successfully removed all non-numeric characters from the input text.