| Author |
Message |
Wosp
Groupie
Joined: 05 Sep 2012
Location: Sweden
Online Status: Offline
Posts: 45
|
  
Topic: Hide part of content
Posted: 28 Aug 2013 at 7:47pm |
|
|
 IP Logged |
|
|
|
praveeng
Senior Member
Joined: 11 Jul 2011
Online Status: Offline
Posts: 165
|
Posted: 29 Aug 2013 at 2:50am |
Hi,
The follwing logic may help you.
Create a formula in the Crystal Report designer with below logic
Replace({Email_database_field},";same@old.com","")
Remove the E-mail field from the report and place the above fomrula in the report.
Right click on the Formula field > select Format field > Select Hyperlink tab
then select "Current E-mail Field Value"
Then Click on OK
--Praveen G
|
|
Praveen Guntuka,
praveen_guntuka@yahoo.com
|
| IP Logged |
|
Wosp
Groupie
Joined: 05 Sep 2012
Location: Sweden
Online Status: Offline
Posts: 45
|
Posted: 29 Aug 2013 at 3:57am |
Great success! worked perfectly...
Thank you for your invaluable support!
|
| IP Logged |
|
Wosp
Groupie
Joined: 05 Sep 2012
Location: Sweden
Online Status: Offline
Posts: 45
|
Posted: 29 Aug 2013 at 10:08pm |
Originally posted by Wosp
Great success! worked perfectly...
Thank you for your invaluable support!
A follow up question, i noticed that we have one more email to hide. But how do i insert one more in the formula, if its possible?
Replace({Email_database_field},";same@old.com","")
|
| IP Logged |
|
praveeng
Senior Member
Joined: 11 Jul 2011
Online Status: Offline
Posts: 165
|
Posted: 30 Aug 2013 at 2:01am |
As per my understanding you want to hide the emails which are having some other text(or email ids)
IF yes, then try with below logic,
Replace({Email_database_field},";same@old.com","")
or
Replace({Email_database_field},"Some text","")
Or if you are requirment is diffrent then please update the post with some test data and your requiremetnt. Then we can understand clearly.. :)
--Praveen G
|
|
Praveen Guntuka,
praveen_guntuka@yahoo.com
|
| IP Logged |
|
Wosp
Groupie
Joined: 05 Sep 2012
Location: Sweden
Online Status: Offline
Posts: 45
|
Posted: 01 Sep 2013 at 7:05pm |
Hi again, tryed it today and getting a "boolean is required here" with the first row in formula marked.
Replace({LEV.EPOST},";tidxxxxx@xxxxxxx.com","")
or
Replace({LEV.EPOST},";birgitta.xxxxxx@xxxxxxx.com","")
|
| IP Logged |
|
praveeng
Senior Member
Joined: 11 Jul 2011
Online Status: Offline
Posts: 165
|
Posted: 03 Sep 2013 at 12:43am |
in which section you are applying the above formulas..
Are you applying in selection formulas or suppress formulas??
|
|
Praveen Guntuka,
praveen_guntuka@yahoo.com
|
| IP Logged |
|
Wosp
Groupie
Joined: 05 Sep 2012
Location: Sweden
Online Status: Offline
Posts: 45
|
Posted: 03 Sep 2013 at 12:59am |
Originally posted by praveengin which section you are applying the above formulas..
Are you applying in selection formulas or suppress formulas??
i made a new formula in field explorer and followed your description in your first answer in this thread, then just added
or
Replace({LEV.EPOST},";birgitta.elfving@xxxxxxxx.com","")
|
| IP Logged |
|
praveeng
Senior Member
Joined: 11 Jul 2011
Online Status: Offline
Posts: 165
|
Posted: 03 Sep 2013 at 2:04am |
Hi,
If your fields are having separator as ; then we can acheive in another way.
Try with below logic,
Numbervar a:= InStr({Database_Field},";");
If a > 0 then
Left({Database_Field},a-1)
Else
{Database_Field}
Try with above code and let me know if it is not working..
--Praveen G
|
|
Praveen Guntuka,
praveen_guntuka@yahoo.com
|
| IP Logged |
|
Wosp
Groupie
Joined: 05 Sep 2012
Location: Sweden
Online Status: Offline
Posts: 45
|
Posted: 03 Sep 2013 at 2:56am |
Amazing, worked like a charm =)
can't thank you enough  |
| IP Logged |
|
|
|
