Announcements
This site is in read only until July 22 as we migrate to a new platform; refer to this community post for more details.

Replacing multiple unique operators in one text field (LongText) with values from another table

HI

  1. Table 1 - contains a list of unique text operators with a field that contains the name of the column in Table 3.
  2. The long text field in Table 2 - contains text in which unique operators from Table 1 are inserted in any order, plus operators can be repeated and the text can consist of only one operator (For example: Any text value {special operator # 1}, more some text {special operator # 27} and so on again the text {special operator # 1}).
  3. Table 3 - A set of columns with values ​​to be returned and replaced in the original text of Table 2, matching with unique operators of Table 1.

My attempts to find a solution resulted in the return of only one value from Table 3, and there can be as many operators and corresponding values as you like in the text box with operators in Table 2.
I ask for help, is it possible to do this in another way?)

0 6 287
6 REPLIES 6
Top Labels in this Space