Re: put away characters in result of query

i supose there is some regular expresion to solve this problem..

"translate" only translate known characters with known characters, but i
need universal solution to translate all character (:alpha:) to '' (empty -
null string)

"Carlos" <miotromailcarlos@xxxxxxxxxxxx> wrote in message
news:1135335647.298272.75090@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> Take a look at TRANSLATE function.
>
> Also, you might want to create a hand-made function that fulfills your
> requirements if needed.
>
> Cheers.
>
> Carlos.
>


.

Relevant Pages

  • Re: Perl Regex Question: how to translate only the leading lettersofaline
    ... clearly will translate all occurrances of "3" to "C", ... regardless of where the characters appear in the string. ... regardless of where they characters appear in the string. ...
    (comp.lang.perl.misc)
  • Re: Convert HTML to String
    ... not be used in this context, you used "const char *" when you meant LPCTSTR, you are ... with what might happen if a was found inside a quoted string for an HTML parameter ... Here's an example string I'd like to translate: ... // Get the next two characters ...
    (microsoft.public.vc.mfc)
  • Re: Translate selected charactes in big files
    ... I've got a requirement to translate codepage 437 box characters into ... I've just knocked up this suggestion, hardcoded translate table (TM's ... Robert AH Prins ...
    (comp.lang.asm.x86)
  • Re: Translate selected charactes in big files
    ... As expected there will be consecutive horizontal bars and a quick analysis of a 2Mb file for series of horizontal bars ... All the others box characters are single occurances, bordered by either blanks or horizontal bars. ... Doing it one-by-one using a simple lookup table is easy, ... A wrote a tiny .com file many years ago to do stuff like this, you simply specified a list of pairs to translate: ...
    (comp.lang.asm.x86)
  • Re: permutation algorithm
    ... in a permutation, ... You can, no doubt, translate the code visible and demonstrated in ... You'll want to use .spliton your string as ... >characters, which y sakuda was so helpful in providing. ...
    (microsoft.public.scripting.vbscript)