Early Access: The content on this website is provided for informational purposes only in connection with pre-General Availability Qlik Products. All content is subject to change and is provided without warranty.
The Strings processor allows you to apply various functions on fields with a string data type, such as formatting, cleaning, adding or removing characters, or searching for specific values.
Usage
The Strings processor requires one input flow and can generate only one output flow.
Properties
Properties to configure to edit your string fields.
Information noteThe properties listed in this section are the default properties for all functions of this processor. Additional properties may need to be defined depending on the function you have selected.
Configuration
Property
Configuration
Function name
Change to upper case: Converts all of the cell text in the field to upper case (capitalize).
Change to lower case: Converts all of the cell text in the field to lower case.
Change to title case: Converts the text content from the field to title case. For example, "this is an example" will become "This Is An Example".
Search and replace: Replaces cells or parts of cells that contain a specific value.
Remove part of the text: Removes specified text from cells in the field.
Contains text: Checks if the cell contains the specified value and returns TRUE or FALSE according to the results. The value entered is case sensitive.
Match similar text: Creates a new field with true or false depending on whether the value is less than or equals the Levenshtein distance of a given value.
Extract a value by index: Extracts a substring from an index position to a new field. Index 0 corresponds to the first character.
Remove non alpha numeric characters: Cleans values that contain unexpected characters by removing all characters that are not 1234567890abcdefghijklmnopqrstuvwxyzáàâäãåæçéèêëíìîïñóòôöõøœßúùûüABCDEFGHIJKLMNOPQRSTUVWXYZÁÀÂÄÃÅÆÇÉÈÊËÍÌÎÏÑÓÒÔÖÕØŒSSÚÙÛÜ. Whitespaces are kept. For example, Q=+l**i€q$ 20%2,0 will become Qlik 2020.
Remove non numeric characters: Cleans numeric values by removing all characters that are not 0-9. Decimal separators, the minus sign, and whitespaces are kept. For example, Q=+l**i€q$ 20%2,0 will become 202,0.
Remove trailing and leading characters: Trims trailing and leading whitespaces.
Add padding: Adds extra characters (padding) on the left or on the right of the original value to match an expected size.
Convert to string: Changes the type of the data to string.
Calculate length: Returns the number of characters of a string (23562 -> 5; 'example' -> 7).
Fields to process
Select the field or fields on which you want to apply a function in the list.
Tip noteIf you want to apply the same function to multiple fields at once, click the Open dialog icon to open a tree view that allows you to select multiple fields.
Create new field
Enable this option to create a new field after applying the function. If you do not enable this option, the existing field will be kept and modified.
Rename new field
Give a custom name to the newly created field.
To rename the processor or edit its description, click the Edit icon next to the processor name in the Properties panel.
Did this page help you?
If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!
Open dialog icon to open a tree view that allows you to select multiple fields.
Edit icon next to the processor name in the Properties panel.