Hi, I would like to find in genre duplicate words and merge them together. This is an example of genre tag: Before AFRICA; AFRICA; NATURAL WORLD; NATURE STUDY; NATURE; DRAMA ADVENTURE; DRAMA WORLD; PERCUSSION; INSTRUMENTS SOLO PERCUSSION; WILDLIFE MOVEMENT; DRAMA ADVENTURE; AFRICA; FILM STYLES A…

Try this one from the other thread: (I adapted it for "/" as separator) $trim($regexp(%Genre%,'(?:(?<=/)|(?<=\A))\s*([^/]*)\s*/(?=.*?(?<=/)\s*\1(?=/|\Z))',,1))

[image] ForSSOund: ... I would like to find in genre duplicate words and merge them together. ... Search there ... https://www.google.de/search?q=site%3Aforum...p;oq=&gs_l= Read there ... Doppelte Genre löschen DD.20141103.1721.CET

[image] ForSSOund: Hi, I would like to find in genre duplicate words and merge them together. This is an example of genre tag: Before AFRICA; AFRICA; NATURAL WORLD; NATURE STUDY; NATURE; DRAMA ADVENTURE; DRAMA WORLD; PERCUSSION; INSTRUMENTS SOLO PERCUSSION; WILDLIFE MOVEMENT; DRAMA ADVENTURE…

[image] DetlevD: Search there ... https://www.google.de/search?q=site%3Aforum...p;oq=&gs_l= Read there ... Doppelte Genre löschen DD.20141103.1721.CET Hi I apreciate your answer as yesterday I couldn't search ... Your type of answer will motivate me to search in the next time even better…

Victor Kostas: You want to keep the first value. That's more complicated. [Edit:] Action: Format value Field: Genre Format string: $regexp($reverse($regexp($regexp($reverse($regexp($regexp(%Genre%,'^(\s+;|\s;+)+|(\s+;|\s;+)+$|((?<=;)\s+)|(\s+(?=;))',),'^|$',';')),'(;[^;]+)(?=(\1|;.*?\1)…

QUOTE (ForSSOund @ Nov 28 2014, 11:21) <{POST_SNAPBACK}> Hi There, On some longer metadata fields I get this error REGEXP ERROR: Regular expression The complexity of matching the regular expression exceeded predefined bounds. Try refactoring the regular expression to make each choice made by t…

Hello! I tried to use this to do the same exact thing, but with " / " as a separator. Ex: World Music / Latin Jazz / Cuban But it did not work. Hopefully someone can help me figure out why and how I can modify it to suit my needs. I tried turning $reverse($regexp($regexp(';'$reverse(%Genre%),'…

It looks a lot like the forum formatter swallowed a couple important *. I don't know, though, where. As a suggestion: you could write an action group that first replaces the slashes in your genre field with the semicolon, then an action to process the field with the existing expression, so that …

Try this one from the other thread: (I adapted it for "/" as separator) Thank you so much dano! I am not sure how it works but it does and this is a game changer for me. Very grateful for your help. Hope it comes back around for you!

Hey dano, if you could point me to the other thread, I would appreciate it as I cannot seem to find it. Also if you be so kind as to bold where I would change the "/" to any other separator, in case I have to modify this in the future. I assume I would just have to change the characters in bold be…

Merge duplicate words

Support

dano November 23, 2020, 4:16pm 13

You need to replace all occurrences of "/"