Will do.....thank you very much for your assistance.
Post by Terry Dykstra [TeamSybase]I think I have a global function that can do that. Look in
CodeXchange (http://www.sybase.com/detail?id=1058501#385)
and under PowerBuilder/InfoMaker look for the 'IM Report
Functions'. The function that I believe will do what you
remove_char (string searchstring, string leftchar, string
rightchar, string whichoccurrence )
Returns: string with all characters removed from leftchar
to rightchar included. If whichoccurrence is set to 1,
only the first matching set is removed, else all
occurrences are replaced. Example: remove_char('<b>some
text</b>', '<', '>', '1') returns 'some text</b>'
Example: remove_char('<b>some text</b>', '<', '>', '*')
returns 'some text'
--
Terry Dykstra (TeamSybase)
http://powerbuilder.codeXchange.sybase.com/
http://casexpress.sybase.com
http://my.isug.com/cgi-bin/1/c/submit_enhancement
to see notes entered by staff. I do not want to see
occurrences of 'InterQual - InterQual Criteria:' or
'End InterQual - InterQual Criteria.' which is
automatically generated by the application and is
included within the co_review_comments field. I am
basically trying to strip out the Interqual text
mentioned above and display the notes entered by staff.
I should only see what is mentioned below. Thank you.
01/19/2009 13:00 Smith, Jane
No need to transfer.
01/18/2009 14:00 Jones, Mary
Auth# 12345
Post by Terry Dykstra [TeamSybase]So of that string occurs multiple times, what do you
want >> to see? I'm confused.
Post by Terry Dykstra [TeamSybase]--
Terry Dykstra (TeamSybase)
http://powerbuilder.codeXchange.sybase.com/
http://casexpress.sybase.com
http://my.isug.com/cgi-bin/1/c/submit_enhancement
Post by unknownThe column co_review_comments is a computed field
which >> > consists of a total of 20 - 2000 character
comments >> > fields. Please see attached. The problem is
that there >> > can be multiple occurrences within
co_review_comments of >> > the string 'End of Interqual'.
I believe that the POS >> > function is for a single
occurrence, not multiple??? >> >
Post by Terry Dykstra [TeamSybase]Post by unknownPost by unknownHi Pat,
it would be interesting to know what exactly the
column 'co_review_comments' contains.
Chris Werner
f+s software gmbh
Chris, >> >> >
Post by Terry Dykstra [TeamSybase]Post by unknownPost by unknownPost by unknownThank you for your response. The end result I am
looking for does not include the final line 'End
of >> >> > Interqual' The text should appear as displayed
Post by Terry Dykstra [TeamSybase]below. >> > When I modified the expression to include
your >> >> > suggestion, the line of text was removed,
'End of >> >> > Interqual' but the first line of text from
the note >> 'No >> > need to transfer' was also truncated.
Any other >> >> suggestions would be greatly appreciated.
Thank you. > >> >> > 01/19/2009 13:00 Smith, Jane
Post by Terry Dykstra [TeamSybase]Post by unknownPost by unknownPost by unknownNo need to transfer.
01/18/2009 14:00 Jones, Mary
Auth# 12345
Post by unknownHi Pat,
I'm not sure what you want the result to be
01/19/2009 13:00 Smith, Jane
No need to transfer.
01/18/2009 14:00 Jones, Mary
Auth# 12345
End of Interqual
MID(co_review_comments, 1, Pos(co_review_comments
,'InterQual - InterQual Criteria:',1) -1) + ' ' +
MID(co_review_comments,Pos(co_review_comments
,'End >> of >> >> InterQual - InterQual
Post by Terry Dykstra [TeamSybase]Post by unknownPost by unknownPost by unknownPost by unknownCriteria.',1)-1, 16)
HTH
Chris Werner
f+s software gmbh
looking >> > for recommendations on the use of the
POS >> >> function in >> > InfoMaker. I have the
following >> >> expression which works >> > fine if there
is only one >> >> occurrence of a string found. >> > If
multiple >> occurences >> are found in the >> >
co_review_comments >> field the line >> 'End of Interqual
- >> Interqual >> Criteria.' is being >> displayed. I do
not want >> > this >> to occur. Any >> recommendations
would be greatly >> >> appreciated. > >> >> >
MID(co_review_comments, 1, >> Pos(co_review_comments >> >>
,'InterQual - InterQual >> Criteria:',1) -1) + ' ' + >>
Post by Terry Dykstra [TeamSybase]Post by unknownMID(co_review_comments >> ,Pos(co_review_comments
,'End of >> >> > InterQual - >> InterQual >> >> >
Criteria.',1)-1,len(co_review_comments)) >> >> >> >
of >> the >> >> > string are found within the
co_review_comments >> field. >> >> > The multiple notes
are correct, but the >> text >> >> > 'Interqual....'
should not display: >> >> >> >
Post by Terry Dykstra [TeamSybase]Post by unknownPost by unknownPost by unknownPost by unknownPost by unknown01/19/2009 13:00 Smith, Jane
No need to transfer.
01/18/2009 14:00 Jones, Mary
Auth# 12345
End of Interqual - Interqual Criteria.