search
Tabula HomeCommunity

ReplaceRegexp

Finds the specified regular expression pattern and replaces it with the new text

ReplaceRegexp("price 100 EUR", "EUR|GBP", "USD") → "price 100 USD"
ReplaceRegexp("1999", "[9]", "0") → "1000"

hashtag
Inputs

ReplaceRegexp(string, searchRegexp, replaceWith, [isCaseSensitive], [allMatches])

  • string - A text value to search in

  • searchRegexp - Regular expression to search for

  • replaceWith - Text to replace with

  • [isCaseSensitive] - [optional: true by default**]** - Set false if search should be case insensitive

  • [allMatches] - [optional: true by default**]** - Set false if only the first match should be replaced

PreviousReplaceNextReverse

Last updated