• Documentation
    • Search documentation
    karat

    +

    K

    API Reference ↗
    Data connectivity & integrationPipeline Builder ExpressionsRegex replace

    Regex replace

    Supported in: Batch, Streaming

    Replace a string using a regex pattern.

    Expression categories: Regex, String

    Declared arguments

    • Expression: Input string to replace.
      Expression<String>
    • Pattern: The regex pattern to match.
      Expression<String>
    • Replace: Replacement string.
      Expression<String>

    Output type: String

    Examples

    Example 1: Base case

    Argument values:

    • Expression: tail_number
    • Pattern: (\w\w)(-)
    • Replace: **-
    tail_numberOutput
    MT-123**-123
    XB-434**-434
    MT-123, XB-434**-123, **-434

    Example 2: Base case

    Argument values:

    • Expression: tail_number
    • Pattern: \
    • Replace: \\
    tail_numberOutput
    this is a backslash \ etcthis is a backslash \ etc

    Example 3: Base case

    Argument values:

    • Expression: path
    • Pattern: \
    • Replace: /
    pathOutput
    path\to\filepath/to/file
    C:\Users\JohnC:/Users/John

    Example 4: Base case

    Argument values:

    • Expression: price
    • Pattern: $
    • Replace: USD
    priceOutput
    Price is $50Price is USD 50
    $100 and $200USD 100 and USD 200

    Example 5: Base case

    Argument values:

    • Expression: price
    • Pattern: $(\d+)
    • Replace: $1 dollars
    priceOutput
    I have $100I have 100 dollars
    $50 and $7550 dollars and 75 dollars

    Example 6: Base case

    Argument values:

    • Expression: tail_number
    • Pattern: (\w\w)(-)
    • Replace: \
    tail_numberOutput
    MT-123\123
    XB-434\434
    MT-123, XB-434\123, \434

    Example 7: Base case

    Argument values:

    • Expression: text
    • Pattern: foo
    • Replace: \$
    textOutput
    foo$
    foo bar foo$ bar $

    Example 8: Base case

    Argument values:

    • Expression: tail_number
    • Pattern: (\w\w)(-)
    • Replace: $
    tail_numberOutput
    MT-123$123
    XB-434$434
    MT-123, XB-434$123, $434

    Example 9: Base case

    Argument values:

    • Expression: tail_number
    • Pattern: (\w\w)(-)
    • Replace: $1
    tail_numberOutput
    MT-123MT123
    XB-434XB434
    MT-123, XB-434MT123, XB434

    Example 10: Null case

    Argument values:

    • Expression: tail_number
    • Pattern: regex
    • Replace: foo
    tail_numberregexOutput
    MT-123(null

    Example 11: Null case

    Description: Null inputs give null outputs.

    Argument values:

    • Expression: null
    • Pattern: (\w\w)(-)
    • Replace: **

    Output: null

    Example 12: Null case

    Description: Null inputs give null outputs.

    Argument values:

    • Expression: foo
    • Pattern: bar
    • Replace: null

    Output: null