PHIL Sawyer
asked on
removing-disabling email properties
Hello
Have a clob field which in some cases an email address is entered.
When this field is shown in reporting tool it has the properties of an email address and if you hover over it and click then yes it goes to email. However, I do not wan that to happen - how can I disable this in my query by maybe using regular expression. Using Oracle 11g
Regards
Have a clob field which in some cases an email address is entered.
When this field is shown in reporting tool it has the properties of an email address and if you hover over it and click then yes it goes to email. However, I do not wan that to happen - how can I disable this in my query by maybe using regular expression. Using Oracle 11g
Regards
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
What is the reporting tool?
ASKER
Crystal Reports
You might be able to kludge something together to manipulate the data but my guess is you can control this from inside the report itself.
We have some world-class Crystal Report Experts on the site and they should be able to help you.
If this cannot be one in Crystal, maybe we can come up with some data hack that will fool Crystal into not seeing it as a link.
We have some world-class Crystal Report Experts on the site and they should be able to help you.
If this cannot be one in Crystal, maybe we can come up with some data hack that will fool Crystal into not seeing it as a link.
ASKER
Thanks
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
How are you running the reports?
mlmcc
mlmcc
ASKER
Hello
Running Crystal Reports locally and from the server.
The field is already set to NO HYPERLINK within the Crystal Report.
For now I have used something like this example to remove email addresses.
select
regexp_replace(' test data at fred.perry@test.com - more emails possible - joe.perry@hotmail.com - more text',
'([^ ]+@[^ ]+)','') as output
from dual
Ideally - it would be good to replace any email addresses as per the followin example - not sure how to do this using regex_replace e.g.
' test data at <email: fred(dot)perry(at)test(dot )com> - more emails possible - <email: joe(dot)perry(at)hotmail(d ot)com> - more text'
Running Crystal Reports locally and from the server.
The field is already set to NO HYPERLINK within the Crystal Report.
For now I have used something like this example to remove email addresses.
select
regexp_replace(' test data at fred.perry@test.com - more emails possible - joe.perry@hotmail.com - more text',
'([^ ]+@[^ ]+)','') as output
from dual
Ideally - it would be good to replace any email addresses as per the followin example - not sure how to do this using regex_replace e.g.
' test data at <email: fred(dot)perry(at)test(dot
If you go out and look for a regex for email addresses, you'll find a ton of them. I'm not sure you'll ever find one that is 100% accurate.
That said, how about you cheat a little. Replace any '@' that has text around it with '<at>'?
See if this helps:
select regexp_replace(
'test data at not an email: @qwert fred.perry@test.com - more emails possible - joe.perry@hotmail.com - more text',
'([^\s]+)(@)([^\s]+)',
'\1<at>\3')
from dual;
That said, how about you cheat a little. Replace any '@' that has text around it with '<at>'?
See if this helps:
select regexp_replace(
'test data at not an email: @qwert fred.perry@test.com - more emails possible - joe.perry@hotmail.com - more text',
'([^\s]+)(@)([^\s]+)',
'\1<at>\3')
from dual;
ASKER
Thanks everybody - I have enough to mull over
ASKER
Thanks