@Replace (Formula Language)
Performs a find-and-replace operation on a text list.
Syntax
@Replace( sourcelist ; fromlist ; tolist )
Parameters
sourcelist
Text list. The list whose values you want to scan.
fromlist
Text list. A list containing the values that you want to replace.
tolist
Text list. A list containing the replacement values.
Return value
replacedList
Text list. The sourcelist, with any values from fromlist replaced by the corresponding value in tolist. If none of the values in fromlist matched the values in sourcelist, then sourcelist is returned unaltered.
Examples
With this example, both sourcelist and fromlist contain "Orange", which is the first value in fromlist. The first value in tolist replaces "Orange" in sourcelist. No other matches were found, so the remainder of sourcelist is left intact; the result is shown as follows:@Replace("Red":"Orange":"Yellow":"Green";"Orange":"Blue";"Black":"Brown")| sourcelist |
fromlist |
tolist |
result |
|---|---|---|---|
| Red |
Orange |
Black |
Red |
| Orange |
Blue |
Brown |
Black (replaces "Orange") |
| Yellow |
Yellow |
||
| Green |
Green |
In this example, the formula looks at the Categories field in each document that it runs against. If one of the keywords in a document's Categories field is "To be assigned" then that keyword is replaced with the name stored in that document's AssignedTo field.
FIELD Categories:= @Trim(@Replace(Categories;
"To be assigned"; AssignedTo));You have a database where you log service requests. Incoming requests are automatically categorized as "To be assigned" by a mail/paste filter. Each day, you review the new (unassigned) service requests, and assign them to technicians by entering the appropriate name in the AssignedTo field. Once a request has been assigned, you want it to appear under that technician's name in the view, instead of under "To be assigned."
Rather than manually categorizing each document a second time, you can write a filter macro, like the preceding one, to delete the documents from the "To be assigned" category and add them to the appropriate technician categories.