Marc Santhoff wrote:
Hi Barbara,
Am Dienstag, den 23.12.2008, 13:58 -0600 schrieb Barbara Duprey:
Earlier in the thread, John indicated that what he wanted was to find
the last period (full stop) and eliminate everything after it. Too bad
there doesn't seem to be a version of LOCATE to find the last instance
of something rather than the first! A search direction parameter for it,
or a LOCATELAST function, would be really handy, I'd think.
If Johns data does not have sentences or parts separated by NL or CR
chars he could use sth. like:
LEFT(TheString, POSITION ('.'+CHAR(10) IN TheString)+1)
If there are concatenated sentences this would only work for double
newlines, leaving on extra NL:
LEFT(TheString, POSITION ('.'+CHAR(10)+CHAR(10) IN TheString)+1)
Can the REPLACE function take a concatenated string like
CHAR(13)+CHAR(10), for example? Trimming the individual characters
wouldn't be enough if they're interspersed with other "whitespace"
characters.
In theorie it should, although I'm not sure if the concatenation has to
be done with '+' or by '||' or maybe using CONCAT().
HTH and Merry Christmas,
Marc
Interesting, Marc - thanks. Not sure whether the data has CHAR(13),
CHAR(10), or both for a new line, it may depend on the OS. But if I
understand this, the second form you have here would work if there are
no internal empty paragraphs, and an extra new line at the end of the
data, right? Sounds promising!
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
