translate function

Using Xmldocument.selectnodes (String XPath) is a convenient way to write XPath, but it takes a bit of effort to do it, and today we found that there was no case-insensitive function in XPath1.0. So it's hard to do the following query         

  1.translate Syntax: Translate (char, from, to) Usage: Returns a string after each character appearing in from is replaced with the corresponding character in to. If the from is longer than the to string, then more characters in from than to will

Little brother to encounter an Oracle update problem, ask you to help: There are several records in the Zz_file, similar in format: (zz01 zz02) gpyi010 apyi/gpyi010 gpyi020 apyi/gpyi020 ..... The younger brother wants to zz01 the Gpy the

TRANSLATE (' char ', ' from_string ', ' to_string ') Translate returns a string that replaces each character in the from_string with the corresponding character in to_string. Translate is a superset of the functionality provided by replace. If the