StringPairReplacer with dynamic input

I should be able to provide an example later on, if nobody else obliges in the meantime.

Deleted

I’ve taken the request to mean multiple string replacements within a single attribute. @pkno can you clarify?

The process I’ve previously used involves the TCL caller which isn’t available in 2024.1 onwards

Does the pattern come from the feature itself or does it come from a global user input?

Could you make a small example with your current situation, and may be something you allready tried? I have a hard time to see what the problem is.

Thank you all for responding. Here is some more info to clarify my request.

@ebygomm

Yes, exactly. The strings I am trying to replace (remap to fulltext equivalents) are stored in a single attribute. Based on the feature, the attribut can require one or multiple replacements.

@jkr_wrk

The pattern (e.g. A1, A2(A3), A4) comes from the feature itself. A quick example could look something like this

with the desired transformation to

these are obviously fillers, but the idea should be clear. What succesfully works is the StringPairReplacer transformer with the caveat that all lookup values are stored in the transformer itself. What I want is to get those values dynamically from a database. The following query in SQLCreator outputs a string which should work as  a valid input for the replacement field input of the transformer and also takes into account possible spaces in the fulltext values:
 

select string_agg(stringpairs,' ') 
from(
    select string_agg(concat(short, ' ',replace(fulltext,' ','_')),' ') as stringpairs
    from table
    group by short, fulltext
    order by length(table.short) desc
    )

What I wasnt able to do is to use that as input for the StringPairReplace transformer. 

Thank you all.

Note: the order of the replacement pairs is important!

In your example you have an abbriviation A12. Make sure that replacement happens before the replacement of A1, as the replacement of A1 will process A12 as well.

Thank you @geomancer 

Based on your idea, I believe I found a solution that works within a single workspace. The one concession I had to make is, that I need to write a temporary text file which contains the replacement pairs. 

Essentially I create this file using the SQLCreator and a writer transformer.

I use this writer as initiator for my database reader to ensure the file is written before the replacement takes place. The file is transformed via a user parameter/scripted parameter value into a string that I can use as input for the StringPairReplacer.