Content Comparison

...

• Expression: You can also use an Expression value type to manipulate the values of existing fields. For example, you can use the Add expression to add two fields together, or the JSON Path expression to parse a JSON object to be stored.

  • Available Function(s)

    • Subtract: Takes two numbers and subtracts the second number from the first. Example: 10 - 3 = 7.

    • Add: Adds two numbers together. Example: 5 + 2 = 7.

    • Multiply: Multiplies two numbers. Example: 4 * 3 = 12.

    • Divide: Divides the first number by the second. Example: 12 / 4 = 3.

    • Append: Adds (appends) an element to the end of a list or array. Example: [1, 2, 3] + 4 = [1, 2, 3, 4].

    • JSON Path: Allows querying and extracting specific values from a JSON object using a path expression. Example: $.store.book[0].title would get the title of the first book in a store.

    • Round: Rounds a number to the nearest whole number or to a specified number of decimal places. Example: 3.7 becomes 4, or 3.14159 rounded to two decimals is 3.14.

    • Absolute Value: Returns the positive value of a number, regardless of whether it's negative. Example: |-5| = 5.

    • Slice: Extracts a portion (or slice) of a list or string. Example: slicing the first 3 characters from "hello" gives "hel".

    • Random Number: Generates a random number within a specified range.

    • Length: Returns the number of elements in an array, or the number of characters in a string. Example: the length of "hello" is 5.

    • Replace: Replaces occurrences of a substring within a string with another substring. Example: replacing "dog" with "cat" in "doghouse" gives "cathouse".

    • Regex Replace: Uses regular expressions to find patterns in a string and replace them with something else. Example: replacing all digits in a string with "X".

...