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 9: | Line 9: | ||
'''Examples''' | '''Examples''' | ||
| - | + | <pre> | |
| + | 'PS_' || A.RECNAME | ||
| + | </pre> | ||
| + | Gives the standard table name from the record name. | ||
| + | |||
===Function: Substr === | ===Function: Substr === | ||
| Line 23: | Line 27: | ||
:Substr(A.DESCR,3) - The description without the first three characters | :Substr(A.DESCR,3) - The description without the first three characters | ||
| + | |||
===Function: Translate === | ===Function: Translate === | ||
| Line 40: | Line 45: | ||
:translate(TextField,'-0123456789','-') - Removes digits from text field. | :translate(TextField,'-0123456789','-') - Removes digits from text field. | ||
| + | |||
==More About Functions== | ==More About Functions== | ||
