Welcome
Fundamentals
Data Sources
Property Mappings
- Settings
- Rule templates
  - Import / Export
    Append text
    Calculate number
    Export manipulation
    Format as decimal number
    Prepend text
    Remove property
    Replace all instances
    Replace first instance
    Round to nearest X
    Select from JSON
    Set cell value
    Set empty cells
    Text manipulation
  - Display
    Number between
    Text contains
    Text ends with
    Text evaluation
    Text is a number
    Text is exactly
    Text is in list
    Text is not a number
    Text is not empty
    Text is not in list
    Text length between
    Text length is exactly
    Text maximum length
    Text minimum length
    Text not contains
    Text not ends with
    Text not starts with
    Text starts with
Advanced
- Derivatives
- Advanced Scripting

Powered by GitBook

#48:

Change request updated 3 months ago

On this page

Property Mappings

Rule templates

Import / Export

Replace first instance

Replace the first instance of the specified text with the new value

PreviousReplace all instances NextRound to nearest X

Last updated 3 months ago

Type: Import/Export

Scope: The rule only applies to the first instance. All following instances will be ignored.

Also see

Example

Cell value: 1, 234, 567.89
Rule values:
- Replace text: , (a single comma)
- With text: (an empty space)
Result: 1 234, 567.00

Replace All Instances