Help with a search&replace

[ownedbycats]

I wanted to make some search & replaces for an Action Chain to populate one column based on values from another, like these (note the latter should also be 'prepend to field,' I forgot to set it before screenshotting it):





As the results show, it also copies all values from Genre (tag-like composite) instead of just the one i want. What should I do?

[BetterRed]

Originally Posted by ownedbycats

What should I do?

Less calibrating and more gardening

BR

[chaley]

Search and replace operates on the individual values, not the set of them, changing only the text that matches. Any values that are not matched are not changed. Said another way, S&R does:

for each item in the list:
    find text in item that matches the search expression
    replace that text with the replacement expression
return the list with replacements

This is what you are seeing.

It seems that what you want is:

for each book:
    if #genre contains text then add new_text to #kobocoll

As you are using action chains I would do this with a template in a single-field-edit action setting #kobocoll. The template would be something like this:

program:
	g = field('#genre');
	k = field('#kobocoll');
	if list_contains(g, ',', '^Cozy Mystery$', '1', '') then
		k = list_union(k, 'Cozy Mysteries', ',')
	fi;
	if list_contains(g, ',', '^(Fantasy|Science Fiction)$', '1', '') then
		k = list_union(k, 'Fantasy & Sci-Fi', ',')
	fi;
	k

You can do it with two search/replace's. One would be something like this:

• source "Template"
• template

  {#genre:'list_contains($, ',', '^Cozy Mystery$', 'Cozy Mysteries', '')'}

• Search for: '(.*)'
• Replace with '\1'

The other would be similar, with the other text values

[ownedbycats]

I'll try that. Hopefully it won't overwrite other existing entries.

EDIT: I used the template. It worked and did not remove existing entries.