Library.REReplace

This function replaces the part(s) of inputExpression that match the regular expression with replaceString.

Syntax Parameters Return Value 
Function Library.REReplace( _
    inputExpression As String, _
    regex As String, _
    replaceString As String, _
    Optional syntax As RegExSyntaxOption = scRESyntaxNormal, _
    Optional options As RegExOptions = scREDefaultOptions) As String
  • inputExpression [in]

Type: String

  • regex [in]

Type: String

  • replaceString [in]

Type: String

  • syntax [in,optional]

Type: RegExSyntaxOption

Default value: scRESyntaxNormal

  • options [in,optional]

Type: RegExOptions

Default value: scREDefaultOptions

Spreadsheet