Reverse order names as headers. Power Headers Forum

Home / Learning / Reverse order names as headers. Power Headers Forum

Please consider registering
guest

Lost password?

Home

Forum

In-Tools Plugins
sp_ArrowRight

Power Headers
sp_ArrowRight

Reverse order names as headers.

The forums are currently locked and only available for read only access

Topic RSS

Reverse order names as headers.

07/28/2011
3:07 pm

mtames

New Member

Members

Forum Posts: 0

Member Since:
07/28/2011

Offline

I'm working on a project where the headers are the names of authors within the book. We need to have them displayed in "last name, first name" format, however some authors have a middle innitial or middle name that needs to follow the first name. We are experimenting with Power Headers in hopes that it will allow us to create headers in this format without having to use invisible text. If you have any suggestions I would greatly appreciate them.

Thanks,

Matt

07/29/2011
3:19 am

Harbs

Admin

Forum Posts: 201

Member Since:
12/19/2010

Offline

Depending on how the names are input, you might be able to use GREP Processors to solve your problem.

Are all the last names a single word? If yes, you can use something like this:

Find: (.+) (\w+)

Change: $2, $1

If the middle initial always has a period after it, you can use that as part of a GREP.

Another possibilty would be to insert zero space characters and use them as delimiters for our GREP expression.

Harbs

11/28/2015
4:32 am

Michel

Member

Members

Forum Posts: 3

Member Since:
05/24/2015

Offline

Hi,

Assuming first/last names can't be easily identified, I think a first Grep research could be useful to "mark" them with a specific char style (0 option).
Then, the header variable would be based on this char style.
The last thing, invert the first and the last name and add a comma-space between them.
With names as Warren Buffet or John F. Kennedy, we could use:

(\u\H+)\h(\u\H+\h)?(\u\H+)
$3, $1

[ID CC 2015 + Power Headers v. 2.0.9]

Cool