Copy one column to another problem

[mirikbb]

Hello,

I am trying to copy content of one custom column to another custom column. Problem which I am experiencing is when the source column contains multiple names split by "&" for example Fname1 Lname1 & Fname2 Lname2

When I use regex replace (.*) with \1 the result in destination column is not the names split with & but names split by coma "," for example Fname1 Lname1,Fname2 Lname2

Source column is defined as "coma separated text, like tags, shown in tag browser" + "Contain names is checked
Destination column is defined as "Test, column shown in tag browser"

Thank you for help. M.

[theducks]

Not elegant, but maybe process in a loop

(.+)(,.+)

Replace in the first pass: \1

Then delete the first tag (.+,)(.+) <in the original
Or capture the next set above

Replace \2

(.+)(,.+)
Replace in all others: &\1 MODE Append

NOT TESTED

[eschwartz]

Why are you copying to a column of a different type?

...

I believe for fields with multiple values, each item is processed separately. You may be able to work around this by using Search Field: {template}

...

Try unchecking "Split result".