Skip to content
PlaidCloud

Table Text Function

Description

Section titled “Description”

The Table: Text Function step applies a text function to the columns of each row that the function reads and writes the result to a new column of a copy of the source table. A NULL in any column the function reads gives NULL.

Source & Options

Section titled “Source & Options”
  • Source Table and Output Table — the table to read and the table to write.
  • Function — the function to apply. The form offers all 15 functions in the table below and shows one column field, labeled for its role, for each argument the selected function reads.
  • Argument columns — the columns the function reads, in the order the table lists them. Each is required.
  • Output column — the name of the column added to the copy of the source.
Function Arguments Result
levenshtein First column, Second column Case-sensitive edit distance, as a whole number
soundex Text Text
json_format JSON Pretty-printed JSON text
json_field JSON, Path Text
json_set_text, json_set_number, json_set_boolean JSON, Path, Value JSON text with the value set
regex_match Text, Pattern, Match case True or false
regex_search Text, Pattern, Occurrence, Match case Position, as a whole number
regex_extract Text, Pattern, Occurrence, Match case Text
regex_replace Text, Pattern, Replacement, Match case Text
to_text_number Number, Pattern Text: the number written with a DecimalFormat-style pattern
to_text_datetime Date/time, Pattern Text: the date written with a date-time pattern
parse_date Text, Pattern The text read as a date
parse_datetime Text, Pattern The text read as a date-time

A converted Savant analysis can carry any of these functions, and they run the same way. A function the form does not offer shows its stored columns and is kept exactly as saved.

Section titled “Related”