I think now I have almost everything working to do the conversion as I want. My Format string is
This performs the conversion correctly and removes the leading spaces. The few remaining problems I have with some three-part names can be resolved manually I think.
The one remaining question I have concerns the separator I'm using to split the fields. All my different composers are separated by \\ rather than ; as the string requires. I've experimented with changing the string to
but that didn't work for me.
Can anyone advise me on either:
- Adapting my string to account for the different separator I use
- Using some other string to convert my separator from \\ to ;
Many thanks for any help you can give me.
PS Ohrenkino thanks for your further advice on three-part names and on using ComposerSort. I'll just do the manual tidy-up for three-part names, but I don't think ComposerSort will work for me.