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 39: | 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. | ||
| + | |||
| + | ==More About Functions== | ||
| + | |||
| + | For more information about functions in [[PeopleSoft Query]], get a copy of our eBook: | ||
| + | |||
| + | [http://www.amazon.co.uk/gp/product/B013ZRND0I/ref=as_li_tl?ie=UTF8&camp=1634&creative=6738&creativeASIN=B013ZRND0I&linkCode=as2&tag=springboardso-21 Using Functions in PeopleSoft Query] | ||
