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 42: | Line 42: | ||
translate(NATIONAL_ID, | translate(NATIONAL_ID, | ||
'0123456789' ||'abcdefghijklmnopqrstuvwxyz'||'ABCDEFGHIJKLMNOPQRSTUVWXYZ' | '0123456789' ||'abcdefghijklmnopqrstuvwxyz'||'ABCDEFGHIJKLMNOPQRSTUVWXYZ' | ||
| - | ,rpad('9',10)||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. | ||
