String Parsing and finding a word in Crystal Report
Posted on 2012-03-29
I have a Oracle CLOB field data which looks like this when I take the field using Crystal Report.
This ticket was submitted by aut Event Manager.Stored token values follow:GUID( MKUMAR057 )DOMAIN( TMATLKTWS1APP002 )SERVICE( TWS )ORIGIN( TWS )OBJECT( J15184 )OBJECTCLASS( SQL_W_USATLKIFSSQ32_001 )PARAMETER ( SQLWKYATLAPP002 )OBJECTLOCATION ( Unknown )FREETEXT( TMATLKTWS1APP002 : SQL_W_USATLKIFSSQ32_001 J15184 has abended in TWS schedule SQLWKYATLAPP002 )
If you check the first bracket starts with a word GUID(someID)
Can I return the someID value in the report using a formula.
The total string length might be long but it always starts with "This ticket was submitted by aut Event Manager.Stored token values follow:GUID( MKUMAR057 )
I have tried with Split and Left Function but unable to achieve what I want until now.