Form Expression

[mauzj]

I'm editing a form expression, and need to display the right part of a string.

e.g. display "aaa" from the string "Word - aaa".

How do I do this? I have no documention and don't know which language is used.

Thanks!


Jon.

 

[reisw]

In the current 7.1.x products there is no built-in function to do what you want. You will have to use an ApplySimple and use the built in functions of your database to perform the trimming. In 7i i believe ther are more functions that allow you to do string manipulations so if you are using that version you won't have to do it on the database side.

 

[nlim]

ltrim and rtrim are available in 7i. so is substr.