From: Mingfang Li 
Hello,
I am writing to seek assitance in macro for the following tasks. Given my
limited knowledge of SAL, I'd appreciate any suggestion the TSE community
can offer.
A portion of the text would look as follows:
...
[AUTHORS] LastName1, FirstName1; LastName2, FirstName2; LastName3, FirstName3
[DATE] August 1997
...
The first task is to move the second and third names to new lines and
delete the "; ", and the second task is to grab the last names and year
information from the DATE field to form a new field, so:
[AUTHORS] LastName1, FirstName1
LastName2, FirstName2
LastName3, FirstName3
[DATE] August, 1997
[NEWFIELD] LastName1, LastName2 & LastName3, 1997
Another added complexity is that the number of authors will differ, for
example, one, two, three, or more than three, the [NEWFIELD] will therefore
be different:
One author: LastName1, 1997
Two authors: LastName1 & LastName2, 1997
Three authors: LastName1, LastName2 & LastName3, 1997
More than three: LastName1, et al., 1997
Again, I would very much appreciate help on this.
Thanks in advance.
Mingfang Li
=======================================================================
Mingfang Li, Ph.D.                                  mailto:mli@csun.edu
Department of Management                           (818) 677-4903 (Fax)
California State University, Northridge         (818) 677-2421 (Office)
Northridge, CA 91330-8245 USA                 http://www.csun.edu/~mli/
========================================================================
---
---------------