Welcome Guest

Pages: 1
Grouping Parts of Names
NicoPostMay 5, 2015, 17:26
Newbie
Posts: 6
Registered:
May 3, 2015, 13:20
Normal topicGrouping Parts of Names

I try to extract the Last Names from ARTIST and SOLOIST and join it in the field GROUPING.
Example: ARTIST "Jack Daniels" and SOLOISTS "Johnny Walker" should join in the field GROUPING as "Daniels, Walker".
Hm, I tried with Actions and Variables but did not succeed until now.
Thanks for any hints.

2MR2PostMay 5, 2015, 20:07
Avatar photo
Administrator
Posts: 2083
Registered:
August 23, 2012, 19:27
Normal topicRe: Grouping Parts of Names

Well I'm not sure how you have Soloist mapped....to a custom field or a UDTI. In the following action I mapped it to Custom 3. The following assumes a 'last name' is preceded by a space. It will place a last name (if any) from Artist and then from Soloist into the Grouping field. If none are found, the Grouping field will be set to empty.

Try this 🙂

Force Grouped Execution
Clear the Grouping field
Copy the Artist field to Variable 1
Find " " from the end in Variable 1, remove it and everything before, set state
if true
Add "\v1" to the end of the list in field Grouping delimiter ", "
endif
Copy the Custom 3 (Soloist) field to Variable 1
Find " " from the end in Variable 1, remove it and everything before, set state
if true
Add "\v1" to the end of the list in field Grouping delimiter ", "
endif

The above code could be enhanced to handle multiple Artists separated by the multi-value delimiter or comma or anything else.

Pages: 1
Mingle Forum by Cartpauj | Version: 1.1.0beta | Page loaded in: 0.01 seconds.