A Social Network for PeopleSoft Professionals
Comments field in an expression
I am trying to extract a sentence from a comments field in ps query and put it into an expression. The sentence is not the only wording in the comments. Can someone give me the correct syntax or some suggestions on where to find examples? Thanks in advance for any help.
Replies to This Discussion
-
Permalink Reply by PSoftPros on -
If there is a particular sentence you will need to create an expression using a function. I'm not sure if you are using Oracle or SQL Server as your database, so the syntax would depend on this.
You can use the INSTR function to find the location of the sentence if you know the sentence. After that you can use the substring function because you know the starting point of the string and the length.
I hope that helps.
-
Permalink Reply by Christine Hunt on -
We are using Oracle. Thanks. I will work with that.
Derek Tomei said:If there is a particular sentence you will need to create an expression using a function. I'm not sure if you are using Oracle or SQL Server as your database, so the syntax would depend on this.
You can use the INSTR function to find the location of the sentence if you know the sentence. After that you can use the substring function because you know the starting point of the string and the length.
I hope that helps.
Latest PeopleSoft Jobs
PRINCIPAL PEOPLESOFT DEVELOPER / ANALYST
Medford , MAJr. Infrastructure Engineer (DBA)
* , TravelPeopleSoft HR Programmer Analyst
* , TravelPeopleSoft Functional IT Business Analyst
Orlando , FloridaPeopleSoft Books
Events
© 2012 Created by PSoftPros.
