• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 381
  • Last Modified:

String Parsing and finding a word in Crystal Report

Dear Team,

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.
0
AnandSahoo
Asked:
AnandSahoo
  • 2
  • 2
1 Solution
 
mlmccCommented:
I assume for the example you want to return MKUMAR057

Will there ever be ( or ) before the GUID?

Try this

Split(Split({YourField},')')[1],'(')[2]

mlmcc
0
 
AnandSahooAuthor Commented:
No there no ( or ) before GUID.\

I have tested this and its just working fine.

Thank You.
0
 
AnandSahooAuthor Commented:
Dear mlmcc,

The above formula was working till now but sudenly i get some error. It shows some array range error saying value should start from 1 to.......
Can u plz help. The total string size is not always same.it can be of more length but starting format is always same.
0
 
mlmccCommented:
That means you have a field with no ) or ( in it.
Try this

If InStr({YourField},')') > 0 and InStr({YourField},'(') > 0 then
     Split(Split({YourField},')')[1],'(')[2]
Else
     "No GUID"

mlmcc
0

Featured Post

Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now