String Calculation Operations

Perform string computations — concatenate, prefix, suffix, pad, split, extract, replace, and more.

String Calculate functions perform computation and manipulation operations on text columns, producing new or modified values in each row. They are available via the column context menu under Calculate > in the Table view.

To access these functions:

1. Open a Dataset in Table view.

2. Click the menu icon (≡) on any text column header.

3. Hover over Calculate > to expand the submenu.

4. Select the desired function.

String Calculate sub-operations

Suffix

Appends a suffix to the value in each row of the selected column. The suffix can be a value from another column or a fixed constant string.

Suffix configuration

Separator options: None, Space, -, ~, _

Example:

Input	Suffix	Separator	Output
invoice	2025	_	invoice_2025

Prefix

Prepends a prefix to the value in each row of the selected column. The prefix can be a value from another column or a fixed constant string.

Prefix configuration

Separator options: None, Space, -, ~, _

Example:

Input	Prefix	Separator	Output
report	Q1	-	Q1-report

Padding

Pads each value in the selected column with a specified character on the left or right side until the string reaches the specified total length.

Padding configuration

💡 Note: Only the first character of the padding value is used, even if multiple characters are provided.

Example:

Input	Direction	Pad Character	Target Length	Output
42	Left	0	5	00042

Concat

Concatenates the value in the selected column with a value from another column or a constant into a single string.

Concat configuration

Separator options: None, Space, -, ~, _

Example:

Column A	Column B	Separator	Output
John	Doe	Space	John Doe

Length

Returns the character length of the value in each row of the selected column as a numeric output.

Example:

Input	Output
dataworkz	9

Remove Special Characters

Removes selected special characters from the value in each row. You can configure which characters to remove by selecting from the available list.

Available characters for removal:

Character	Symbol
Forward slash	/
Pound / Hash	#
Exclamation	!
Dollar	$
Percentage	%
Caret	^
Ampersand	&
Asterisk	*
Semicolon	;
Colon	:
Open brace	{
Close brace	}
Equal	=
Hyphen	-
Underscore	_
Back quote	`
Tilde	~
Open bracket	(
Close bracket	)
Dot	.
Comma	,
Backward slash	\

Extract Domain from URL

Extracts the domain portion from a URL string in each row.

Example:

Input	Output
https://www.dataworkz.com/docs/overview	dataworkz.com

Clean URL From Raw

Cleans and normalizes a raw URL string, removing extraneous characters, encoding artifacts, or formatting inconsistencies to produce a clean, usable URL.

Split Value

Splits the value in each row into two parts using a specified delimiter.

Split Value configuration

Field	Description
Split By	The delimiter character or string to split on.
Select value from	Whether to return the value from the Left or Right of the split.
Choose value	Whether to use the First or Last occurrence of the delimiter.
Include pattern in result	When checked, retains the delimiter in the output.

Example:

Input	Delimiter	Occurrence	Output (Part 1)	Output (Part 2)
[e-mail]	@	First	first.last	email.com

Pattern Matcher

Evaluates each row in the selected column against a provided pattern and returns a boolean result (true or false) indicating whether the value matches.

Pattern Matcher configuration

Field	Description
Pattern to match	The regex pattern or string to test each value against.
Create New Column	When enabled, writes the boolean result to a new column.
Column Name	The name of the new column.

Example:

Input	Pattern	Output
[e-mail]	Email regex	true
not-an-email	Email regex	false

SubString

Extracts a portion of the string in each row based on specified start and end index positions.

SubString configuration

Field	Description
Start From (included)	The character index at which extraction begins (0-based, inclusive).
End At Index (excluded)	The character index at which extraction ends (exclusive).

Example:

Input	Start Index	End Index	Output
dataworkz	0	4	data

Replace All Occurrence

Replaces every occurrence of a specified string or regex pattern within each row's value with a provided replacement string.

Replace All Occurrence configuration

Field	Description
Replace text/regex	The string or regex pattern to find.
With	The replacement string.
Create New Column	When enabled, writes the result to a new column.

Example:

Input	Find	Replace With	Output
foo bar foo	foo	baz	baz bar baz

Split and Unnest

Splits the value in each row using a specified delimiter and unnests the resulting parts into separate rows, expanding the Dataset vertically.

Split and Unnest configuration

Field	Description
Split using Pattern	The delimiter pattern to split on.
Create New Column	When enabled, writes the unnested values to a new column.
Column Name	The name of the new column.

Example:

Input	Delimiter	Output Rows
a,b,c	,	a / b / c (3 rows)

💡 Note: Unlike Split Value, which produces two columns in the same row, Split and Unnest creates one new row per split segment.