vba:functions:rxlib
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision | Last revision Both sides next revision | ||
|
vba:functions:rxlib [13.10.2016 11:15:41] yaslaw |
vba:functions:rxlib [13.10.2016 11:16:18] yaslaw |
||
|---|---|---|---|
| Line 80: | Line 80: | ||
| ==== Beispiele rxLookup() ==== | ==== Beispiele rxLookup() ==== | ||
| - | <code vb>SELECT t.username, rxLookup(t.username, '/(ruedi)/i') AS Ruedi | + | <code sql>SELECT t.username, rxLookup(t.username, '/(ruedi)/i') AS Ruedi |
| FROM myTable t | FROM myTable t | ||
| WHERE rxMatch(t.username, '/(ruedi)/i'); | WHERE rxMatch(t.username, '/(ruedi)/i'); | ||
| Line 119: | Line 119: | ||
| ==== Beispiele rxReplace() ==== | ==== Beispiele rxReplace() ==== | ||
| - | <code vb>SELECT t.username, rxReplace(t.username, '/(hans)([-\s]?)ruedi/i', '$1$2Peter') AS Ruedi | + | <code sql>SELECT t.username, rxReplace(t.username, '/(hans)([-\s]?)ruedi/i', '$1$2Peter') AS Ruedi |
| FROM myTable t | FROM myTable t | ||
| WHERE rxMatch(t.username, '/(ruedi)/i'); | WHERE rxMatch(t.username, '/(ruedi)/i'); | ||
vba/functions/rxlib.txt · Last modified: 30.01.2017 12:58:55 by yaslaw
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: GNU Free Documentation License 1.3
