• 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)