REPLACE tablename[TEXT, field, param1, verb, newverb, param2]

The syntax above replaces data from a table based on the expression parameters.

  • tablename: The table name with full path.
  • TEXT: Indicates text type data.
  • field: A desired table's column.
  • param1: Can be the following:
    • -1: Iterating from bottom to top changing first match.
    • 0: Iterating from top to bottom. All matches will be changed.
    • 1: Iterating from top to bottom changing first match.
  • verb: The pattern we are looking for to replace.
  • newverb: New pattern to change to.
  • param2: Can be the following:
    • *: Indicates that we want like pattern to change. Without asterisk full matches will be changed only, not case sensitive.
    • !: Changing all cells which are not matching the pattern.



Theoretical example

Let's say we are using the following table:


Command:

REPLACE table01[TEXT, 2, 0, record, new record, *]

Output:



REPLACE tablename[type, field, param1, verb, newverb]

The syntax above replaces data from a table based on the expression parameters.

  • tablename: The table name with full path.
  • type: Can be the following:
    • NUM: Indicates number type data.
    • DATE: Indicates date type data.
    • TIME: Indicates time type data.
    • DATETIME: Indicates datetime type data.
  • field: A desired table's column.
  • param1: Can be the following:
    • -1: Iterating from bottom to top changing first match.
    • 0: Iterating from top to bottom. All matches will be changed.
    • 1: Iterating from top to bottom changing first match.
  • verb: The pattern we are looking for to select.
  • newverb: New pattern to change to.



Theoretical example

Command:

REPLACE table01[NUM, 1, 0, 8, 20]

Output: