On Wed, Sep 20, 2006 at 09:31:20PM +0200, Maarten Sneep wrote:
> Hi,
> 
> I'd like to sort a list of names (with some extra tab delimited  
> columns after the names). However, as must names are in Dutch, there  
> are quite a few prefixes (Van, Van den, De, ?) which should be  
> ignored. So "Van den Berg" is sorted before "Janssen", and "De Vries"  
> comes at the end of the list.
> 
> How can I prepare a grep pattern for the sort command that does this?  
> I need the last word (without spaces), before the first tab. I think  
> that covers most names, in Dutch at least, although some French names  
> (d'Hondt) will be sorted in the wrong place.
> 
> Any suggestions?

This might work for you.  I could be more certain if I saw an example of
your file.  :)


Before sorting...

Find

^(.*?) ([^\t ]+)\t

Replace

\2 \1\t


After sorting...

Find

^([^\t ]+) (.*?)\t

Replace

\2 \1\t


Ronald

-- 
------------------------------------------------------------------
Have a feature request? Not sure the software's working correctly?
If so, please send mail to <[EMAIL PROTECTED]>, not to the list.
List FAQ: <http://www.barebones.com/support/lists/bbedit_talk.shtml>
List archives: <http://www.listsearch.com/BBEditTalk.lasso>
To unsubscribe, send mail to:  <[EMAIL PROTECTED]>

Reply via email to