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
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
