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.