• How to make end of cell character part of find...replace

    From Styler001@21:1/5 to All on Sun Mar 17 05:12:51 2019
    This is going to be hard to visualize without the actual mocked-up table
    I'm working with, but I'll give it a shot. You may recognize this as
    being quotes from "A Tale of Two Cities". I couldn't use the actual
    text in this example, since it's work-related.

    I've got a table that I need to do a find...replace. I'll try to show
    it here. Each lined-off section is a cell in a table.

    ---------------------------------------------------------------------------------
    • It was the year of Our Lord one thousand seven hundred and
    seventy-five.¤ ---------------------------------------------------------------------------------
    • Spiritual revelations were conceded to England at that favoured
    period, as at this.¤ ---------------------------------------------------------------------------------
    • Wo-ho! said the coachman.¤ ---------------------------------------------------------------------------------
    • What o'clock do you make it, Joe?
    • Ten minutes, good, past eleven.
    • ¤ ---------------------------------------------------------------------------------
    • What do you say, Tom?¤ ---------------------------------------------------------------------------------
    • They both listened.¤ ---------------------------------------------------------------------------------
    • I say a horse at a canter coming up, Joe.
    • I say a horse at a gallop, Tom.¤ ---------------------------------------------------------------------------------
    • Is that the Dover mail?

    • ¤ ---------------------------------------------------------------------------------
    • Why do you want to know?¤ ---------------------------------------------------------------------------------
    • I want a passenger, if it is.¤ ---------------------------------------------------------------------------------

    As you can see, each cell ends with a ¤ character when viewing the
    formatting in the document, but I haven't been able to figure out a way
    to include that as part of the find.

    I can easily enough do a find...replace where "^l• ^l• " is replaced
    with nothing when there are two "blank" lines (lines with just the • and
    a space "• ". But, when there is only one blank line, as in cell 4, if
    I try to replace "^l• ", cell 7 then turns into "• I say a horse at a
    canter coming up, Joe.I say a horse at a gallop, Tom." with what should
    be two lines but are now crammed together.

    Here's what I would expect as the final result if I could figure out how
    to replace things like I want.

    ---------------------------------------------------------------------------------
    • It was the year of Our Lord one thousand seven hundred and
    seventy-five.¤ ---------------------------------------------------------------------------------
    • Spiritual revelations were conceded to England at that favoured
    period, as at this.¤ ---------------------------------------------------------------------------------
    • Wo-ho! said the coachman.¤ ---------------------------------------------------------------------------------
    • What o'clock do you make it, Joe?
    • Ten minutes, good, past eleven.¤ ---------------------------------------------------------------------------------
    • What do you say, Tom?¤ ---------------------------------------------------------------------------------
    • They both listened.¤ ---------------------------------------------------------------------------------
    • I say a horse at a canter coming up, Joe.
    • I say a horse at a gallop, Tom.¤ ---------------------------------------------------------------------------------
    • Is that the Dover mail?¤ ---------------------------------------------------------------------------------
    • Why do you want to know?¤ ---------------------------------------------------------------------------------
    • I want a passenger, if it is.¤ ---------------------------------------------------------------------------------

    If anyone can help with this, I'd greatly appreciate it.




    --
    Styler001

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)