Skip to Content
0
Former Member
Aug 13, 2008 at 12:04 AM

Can i please get an equivalent code in crystal reports XI ????

110 Views

I am using regular expression i.e. @pattern and @text, so dunno how do i intialize them or use them in formula editor of crystal reports??

declare @pattern nvarchar(max), @text nvarchar(max)

select

@text= {v_service_call.journal_history} from v_service_call

select

@pattern='(\d)/(\d)/(\d)\s(\d):(\d)'

select

[Text] from dbo.RegexMatches(@text,@pattern)

Also wht is the equivalent function for Pattern matching function RegexMatches in Crystal REports XI,

The above code work beautifully when i wrote it in SQL 2005 server,

however,

i am not sure how to use the same code in formula editor of crystal reports.

please suggest something...

thanks,

abhi.