sandr

Search and replace text.

   sandr(search, replace, text)

Returns the text expression with the search REX expression replaced with the replace expression. See the REX documentation and the Vortex sandr function documentation for complete syntax of the search and replace expressions.

     SELECT  NAME, sandr('>>=SYS=', 'SYSTEM TABLE ', NAME) DESC
     FROM    SYSTABLES

The results are:

  NAME                DESC
 SYSTABLES            SYSTEM TABLE TABLES
 SYSCOLUMNS           SYSTEM TABLE COLUMNS
 SYSINDEX             SYSTEM TABLE INDEX
 SYSUSERS             SYSTEM TABLE USERS
 SYSPERMS             SYSTEM TABLE PERMS
 SYSTRIG              SYSTEM TABLE TRIG
 SYSMETAINDEX         SYSTEM TABLE METAINDEX

Added in version 3.0


Copyright © Thunderstone Software     Last updated: Sep 12 2017
Copyright © 2017 Thunderstone Software LLC. All rights reserved.