Einfache Lösung ... siehe dort ...
Regular Expressions
Regular Expressions
Umfangreiche Lösung hier ...
The Artist / Artist, The $regexp(%ARTIST%,'(?#From "The Artist" to "Artist, The")^(?i)(the|der|die|das)\s(.*)$','$2, $1') $regexp('Der Pavian','(?#From "The Artist" to "Artist, The")^(?i)(the|der|die|das)\s(.*)$','$2, $1') $regexp(%ARTIST%,'(?#From "Artist, The" to "The Artist")^(?i)(.*)\,\s*(the|der|die|das)$','$2 $1') $regexp('Pavian, Der','(?#From "Artist, The" to "The Artist")^(?i)(.*)\,\s*(the|der|die|das)$','$2 $1')Siehe auch ...
/t/7449/1
DD.20120530.2240.CEST