alphabetizing

[Wayne]

How does one alphabetize a list (e.g. poems and novels, combined) that
includes some items with leading / trailing parentheses and some that don't?

 

[JoAnn Paules]

Can you strip out the punctuation marks?

 

[Wayne]

Of course that would make it simple... to alphabetize... but then I'd have to
locate all of the poems among 986 pages of titles and put the quotation marks
back.
--
Hokie

Can you strip out the punctuation marks?

--

JoAnn Paules
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"

How does one alphabetize a list (e.g. poems and novels, combined) that
includes some items with leading / trailing parentheses and some that
don't?

 

[JoAnn Paules]

So you want to sort but ignore punctuation? I'd be tempted to sort them then
rearrange the others manually. But that's just me.

--
JoAnn Paules
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"

Of course that would make it simple... to alphabetize... but then I'd have
to
locate all of the poems among 986 pages of titles and put the quotation
marks
back.
--
Hokie

Can you strip out the punctuation marks?

--

JoAnn Paules
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"

How does one alphabetize a list (e.g. poems and novels, combined) that
includes some items with leading / trailing parentheses and some that
don't?

 

[grammatim]

You could use a wildcard search to remove the parentheses and quotes
-- and in the same pass to apply, say, a color to the affected lines;
then sort the entries; then do another wildcard search to remove the
color and replace the parens and quotes.

Of course that would make it simple... to alphabetize... but then I'd have to
locate all of the poems among 986 pages of titles and put the quotation marks
back.
--
Hokie

Can you strip out the punctuation marks?

--

JoAnn Paules
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"

 

[Wayne]

Does that mean that there is no way to "automatically" do it? If so, then
I'll just have to gut it out... with approximately 50,000 titles to
alphabetize, perhaps 1500 of which have quotation marks.... a LOT of hand
work.

--
Hokie

So you want to sort but ignore punctuation? I'd be tempted to sort them then
rearrange the others manually. But that's just me.

--
JoAnn Paules
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"

Of course that would make it simple... to alphabetize... but then I'd have
to
locate all of the poems among 986 pages of titles and put the quotation
marks
back.
--
Hokie

Can you strip out the punctuation marks?

--

JoAnn Paules
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"


How does one alphabetize a list (e.g. poems and novels, combined) that
includes some items with leading / trailing parentheses and some that
don't?

 

[Greg Maxey]

Wayne,

Well no there is no such thing a wishing Word would do something and it
happen automatically. You have to take certain steps. Peter (grammatim)
gave you the steps. You could put similar steps in a macro and then run the
macro on your list:

Sub ScratchMacro()
Dim oRng As Word.Range
Set oRng = ActiveDocument.Range
With oRng.Find
.Text = """*"""
.MatchWildcards = True
.Wrap = wdFindContinue
While .Execute
oRng.Text = Mid(oRng.Text, 2, Len(oRng.Text) - 2)
oRng.Font.Color = wdColorBrightGreen
Wend
End With
ActiveDocument.Range.Sort
Set oRng = ActiveDocument.Range
With oRng.Find
.Font.Color = wdColorBrightGreen
.Wrap = wdFindContinue
While .Execute
oRng.Text = Chr(34) & oRng.Text & Chr(34)
oRng.Font.Color = wdColorAutomatic
Wend
End With
End Sub


--
Greg Maxey - Word MVP

My web site http://gregmaxey.mvps.org

Does that mean that there is no way to "automatically" do it? If so, then
I'll just have to gut it out... with approximately 50,000 titles to
alphabetize, perhaps 1500 of which have quotation marks.... a LOT of hand
work.

--
Hokie

So you want to sort but ignore punctuation? I'd be tempted to sort them
then
rearrange the others manually. But that's just me.

--
JoAnn Paules
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"

Of course that would make it simple... to alphabetize... but then I'd
have
to
locate all of the poems among 986 pages of titles and put the quotation
marks
back.
--
Hokie


:

Can you strip out the punctuation marks?

--

JoAnn Paules
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"


How does one alphabetize a list (e.g. poems and novels, combined)
that
includes some items with leading / trailing parentheses and some
that
don't?

 

[Wayne]

Thanks! This looks like it might work. Will be back later if it doesn't.
--
Hokie

You could use a wildcard search to remove the parentheses and quotes
-- and in the same pass to apply, say, a color to the affected lines;
then sort the entries; then do another wildcard search to remove the
color and replace the parens and quotes.

Of course that would make it simple... to alphabetize... but then I'd have to
locate all of the poems among 986 pages of titles and put the quotation marks
back.
--
Hokie

Can you strip out the punctuation marks?

--

JoAnn Paules
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"

How does one alphabetize a list (e.g. poems and novels, combined) that
includes some items with leading / trailing parentheses and some that
don't?

 

[grammatim]

Greg's macros tend to work first time, every time. (But he didn't add
the link to his "How to load a macro" page!)

If you're likely to need to do this more than once, then definitely
use the macro.

Wayne,

Well no there is no such thing a wishing Word would do something and it
happen automatically.  You have to take certain steps.  Peter (grammatim)
gave you the steps.  You could put similar steps in a macro and then run the
macro on your list:

Sub ScratchMacro()
Dim oRng As Word.Range
Set oRng = ActiveDocument.Range
With oRng.Find
    .Text = """*"""
    .MatchWildcards = True
    .Wrap = wdFindContinue
    While .Execute
      oRng.Text = Mid(oRng.Text, 2, Len(oRng.Text) - 2)
      oRng.Font.Color = wdColorBrightGreen
    Wend
End With
ActiveDocument.Range.Sort
Set oRng = ActiveDocument.Range
With oRng.Find
  .Font.Color = wdColorBrightGreen
  .Wrap = wdFindContinue
  While .Execute
    oRng.Text = Chr(34) & oRng.Text & Chr(34)
    oRng.Font.Color = wdColorAutomatic
  Wend
End With
End Sub

--
Greg Maxey -  Word MVP

My web sitehttp://gregmaxey.mvps.org
Word MVP web sitehttp://word.mvps.org

Does that mean that there is no way to "automatically" do it?  If so,then
I'll just have to gut it out... with approximately 50,000 titles to
alphabetize, perhaps 1500 of which have quotation marks.... a LOT of hand
work.

So you want to sort but ignore punctuation? I'd be tempted to sort them
then
rearrange the others manually. But that's just me.
--
JoAnn Paules
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"
Of course that would make it simple... to alphabetize... but then I'd
have
to
locate all of the poems among 986 pages of titles and put the quotation
marks
back.
--
Hokie
:
Can you strip out the punctuation marks?
--
JoAnn Paules
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"
How does one alphabetize a list (e.g. poems and novels, combined)
that
includes some items with leading / trailing parentheses and some
that
don't?