Using Expressions in PS Query
From TekiWiki
This whole wiki has now moved to http://www.springboardsolutions.com/wiki
Go to this page Using Expressions in PS Query
| Line 41: | Line 41: | ||
<pre> | <pre> | ||
translate(NATIONAL_ID, | translate(NATIONAL_ID, | ||
| - | '0123456789'||'abcdefghijklmnopqrstuvwxyz'||'ABCDEFGHIJKLMNOPQRSTUVWXYZ' | + | '0123456789' ||'abcdefghijklmnopqrstuvwxyz'||'ABCDEFGHIJKLMNOPQRSTUVWXYZ' |
| - | ,rpad('9',10)||rpad('x',26)||rpad('X',26)) | + | ,rpad('9',10)||rpad('x',26) ||rpad('X',26)) |
translate(TextField,'-0123456789','-') - Removes digits from text field. | translate(TextField,'-0123456789','-') - Removes digits from text field. | ||
