Replacing Strings

To replace character strings in table columns, use the Edit Column command from the context menu.

\1 denotes the entire character string as is

\2 denotes the first section in brackets

\(n+1) denotes the n-th section in brackets

The character # can be used for automatic numbering

Examples:

Current value: FBxyz_01	enclose characters to be retained in brackets
Search for: (*)xyz_(*)	(FB) is the first section in brackets, (01) is the second section in brackets
Replace by:	results in
\1	FBxyz_01
\2uvw_\3	FBuvw_01
\3u\2	01uFB
##	automatic numbering with two digits, i.e. 01 to 99; from 100 on, the numbering will start over with 00, 101 will become 01, etc.

In practice, these flexible logics enable to perform any operation required to convert strings.