×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
On Fri, Jun 27, 2014 at 3:42 PM, Dave <dfx1@xxxxxxxxxxxxxx> wrote:
Looks like it would be
possible with Translate but even more unreadable.
Not even possible. That's just not how TRANSLATE works.
TRANSLATE maps individual characters to other single characters. If
you map, say 'xyz' to '123', then EVERY instance of 'x' in the string
to be translated becomes '1'. Every instance of 'y' becomes '2'.
More than one of these transformations can have the same destination
character. So 'xyz' can be mapped to '113' if you want. This will
turn every instance of 'x' into '1' and also every instance of 'y'
into '1'.
For example, the expression
translate('Hello, world!', '123', 'olH')
has the following components:
String to be translated: 'Hello, world!'
Map from: 'olH'
Map to: '123'
Resulting string: '3e221, w1r2d!'
This is nothing like what you're trying to do.
John
midrange.com
