This is how I do it today, but I suspect there are better ways to do it?
|
I would think it is easier to use locate( ..., '\\', -1 ) to find the last backslash and then split the string at that location.
Note that backslashes should be doubled ... otherwise sequences like \n will get interpreted as newline (similar for \r and \t and a few others) HTH Wow, was just about to post something comparable but had to lookup the third LOCATE() parameter, as usual:)
(18 Jan '16, 11:46)
Volker Barth
|