Change the text in the values of a specified text column from one character sequence to another.

Syntax:

ChangeTextInTextColumn, textColumnname, fromString, toString 

Parameters:

textColumnName – name of the text column

fromString - the string of characters to search for and replace 

toString - the string of characters to be inserted

Examples:

Looks for the string "January" within the text column named "Month", and replaces the value to "Jan".

Looks for the character "/" within the text column named "Month", and replaces the value with "-". So "2008/01/02" will change to "2008-01-02".  

Author Mode menu:

Edit -> Search/Replace Text within Text Column