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 32: | Line 32: | ||
'''Examples''' | '''Examples''' | ||
| + | |||
| + | Show the format of NATIONAL_ID - useful in a group by query: | ||
:translate(NATIONAL_ID, | :translate(NATIONAL_ID, | ||
| Line 37: | Line 39: | ||
,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. | ||
