Basic Transforms

No Spaces

Removes every space in the value. Example: "AC 23 7 B" → "AC237B"

Not Blank

Checks whether the field contains anything. Returns true if filled, false if empty. Example: "Jones" → true, "" → false

Phone

Removes everything except numbers and +. Example: "(020) 8123 4444" → "02081234444"

Plain Text

Removes HTML tags and leaves only text. Example: "<b>John</b> Smith" → "John Smith"

URL Encode

Makes a value safe for a URL. Example: "John Smith" → "John%20Smith"

UTF8 to ASCII

Converts accented or special characters to basic letters. Example: "François" → "Francois"

Character & String Transforms

Lower case

• Value to match example: John Smith

• Field example: john smith

Upper case

• Value to match example: john smith

• Field example: JOHN SMITH

Title case

• Value to match example: JOHN SMITH

• Field example: John Smith

Postcode

Uppercase and add a space before the last three characters

• Value to match example: cw11aa

• Field example: CW1 1AA

Left

Takes the first n characters. Example: Value "ABCDEFG", n=3 → "ABC"

Right

Takes the last n characters. Example: Value "ABCDEFG", n=3 → "EFG"

Html

Converts text into HTML. Example: "Line break here" → "Line break here<br>"

Host

Extracts the domain from a URL. Example: "https://example.org/page" → "example.org"

Name

Breaks a full name into components. Example: "Dr Sarah Thompson" → Title: Dr, First: Sarah, Last: Thompson

Date Transforms

Math & Number Transforms

Multiply

Multiplies the value by a given number. Example: 10 × 5 → 50

Multiply Currency

Same as above, but treats the number as money. Example: £12.50 × 2 → £25.00

Number

Converts text into a clean number. Example: "1,234.00" → 1234

Dollar/Pound

Divides by 100 (useful for values stored in pence/cents). Example: "499" → "4.99"

Sort Code

Formats a 6‑digit sort code. Example: "403025" → "40-30-25"

Text Logic Transforms

Note: All transforms in this section include a Value to match field. Below each is an example of what to enter.

Starts With

Allows the value if it begins with the phrase you specify.

• Value to match example: ABC

• Field example: ABC123 → kept, 123ABC → removed

Does Not Start With

Allows the value only if it doesn’t begin with the phrase.

• Value to match example: TEMP

• Field example: TEMP_44 → removed, LIVE_44 → kept

Ends With

Allows the value only if it ends with the phrase.

• Value to match example: .com

• Field example: example.com → kept, example.org → removed

Does Not End With

Allows the value only if it does not end with the phrase.

• Value to match example: .tmp

• Field example: report.tmp → removed, report.pdf → kept

Contains

Allows the value only if it includes the phrase.

• Value to match example: VIP

• Field example: VIP Donor → kept, Donor → removed

Does Not Contain

Allows the value only if it does not include the phrase.

• Value to match example: TEST

• Field example: TEST_Record → removed, Donor_Record → kept
  

Yes/No & Boolean Transforms

Boolean

Converts text into true or false. Example: "yes" → true, "no" → false

Yes/No

Converts a value into yes or no. Example: "X" → "yes", "" → "no"

Yes/No (CSV)

Checks whether the value exists in a comma‑separated list. Example: CSV list = "Red,Green,Blue" Value = "Blue" → yes

Yes/No (Fuzzy CSV)

Same as above, but partial matches count. Example: CSV list = "United Kingdom,United States" "UK" → yes

Yes/Blank

If a value exists, return yes. If not, leave blank. Example: "data" → "yes", "" → ""

OptIn/OptOut

Always returns one of the two values. Example: Missing text → "OptOut" Provided value → "OptIn"


Invert

Other (Advanced)

Import ID to ID

Converts an Import ID into an NXT‑compatible ID. Example: "000001-593-00012898" → "12898"