Hello friends! I have this data: Artist Dido; Eminem Eminem; RBX; Sticky Fingaz Dr. Dre; Eminem; Nate Dogg; Snoop Dogg; Xzibit what I need is to transform the character ";" in "feat." another in "comma" and another in "&" getting the following result: Artist Dido feat. Eminem Eminem feat. R…

Regular expressions are always your friend.. If you get a chance learn them :slight_smile: Use the following: Action type: Format value Field: ARTIST Formatstring: $regexp($regexp($regexp(%artist%,';(\s*[^;]+);\s*([^;]+)$',;$1 & $2),'^([^;]+);\s*',$1 feat. $2),';',',') Results: "Dido; Eminem…

QUOTE (stevehero @ Sep 15 2016, 12:52) <{POST_SNAPBACK}> Regular expressions are always your friend.. If you get a chance learn them :slight_smile: Use the following: Action type: Format value Field: ARTIST Formatstring: $regexp($regexp($regexp(%artist%,';(\s*[^;]+);\s*([^;]+)$',;$1 & $2),'^([^;]…

Mac: Muito obrigado! o fato de todo suporte ser em inglês dificulta um pouco o entendimento de algumas funções, mas irei me esforçar e estudar mais sobre isso! abraço. De nada hombre.. Yo hablo un poquito espanól asi que yo entiendo tu problema jaja :wink:

Replace the same character for more than a character

Support

stevehero September 17, 2016, 7:07pm 4

De nada hombre.. Yo hablo un poquito espanól asi que yo entiendo tu problema jaja

Could anyone give me some advice on how to make an action group for this purpose?