Reverse order names as headers. Power Headers Forum

Avatar

Please consider registering
guest

sp_LogInOut Log In

Lost password?
Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 4 characters - maximum search word length is 84 characters

The forums are currently locked and only available for read only access
sp_Feed Topic RSS sp_TopicIcon
Reverse order names as headers.
07/28/2011
3:07 pm
Avatar
mtames
New Member
Members
Forum Posts: 0
Member Since:
07/28/2011
sp_UserOfflineSmall 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
Avatar
Harbs
Admin
Forum Posts: 201
Member Since:
12/19/2010
sp_UserOfflineSmall 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
Avatar
Michel
Member
Members
Forum Posts: 3
Member Since:
05/24/2015
sp_UserOfflineSmall 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

@ Gabe, if I'm wrong, thanks to tell me! Wink

11/30/2015
3:09 am
Avatar
Harbs
Admin
Forum Posts: 201
Member Since:
12/19/2010
sp_UserOfflineSmall Offline

Looks good to me.

Thanks for helping out! :)

Forum Timezone: America/New_York

Most Users Ever Online: 197

Currently Online: ladieschristian, coatmoncler, leisheq93511@163.com
5 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

jacksonlame: 18

niftyix: 10

Ulrich Bogun: 9

Adrian: 8

jackferthomas: 8

todaleha: 7

Member Stats:

Guest Posters: 1

Members: 5717

Moderators: 0

Admins: 2

Forum Stats:

Groups: 3

Forums: 23

Topics: 279

Posts: 705

Newest Members: kevin bear, Muskan, Agra Escorts, Lisa, Morgan, bangalore

Administrators: In-Tools: 11, Harbs: 201