I did try something similar but on the last pattern the text value in one case was
AC(Departament d'Astronomia i Astrofísica. Universitat de València. C/Dr. Moliner 50, 46100 Burjassot (València), Spain)
And was having problems with the (Valencia) portion and if I used the | was getting too much but I will try this or variant to see if it can be consistent. Sorry I don't have the exact pattern from the previous attempt that was similar to this split.
In reply to Re^2: Character Text Delimiters
by Ninthwave
in thread Character Text Delimiters
by Ninthwave
| For: | Use: | ||
| & | & | ||
| < | < | ||
| > | > | ||
| [ | [ | ||
| ] | ] |