Partial Print
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=6645
Printed Date: 28 Apr 2024 at 9:50am
Topic: Partial Print
Posted By: nalfein
Subject: Partial Print
Date Posted: 09 Jun 2009 at 11:41pm
|
Hello all
I've a field that have this value structure john AB eatapple After the AB (that is a standard) the value of the field can change as john AB eatapple john AB eatbigapple john AB eatlittleapple I need a command on cr that says "print everything after the AB no matter of lenght" What can I do? I've tried with right function but basically is a count of number of char to print and I, as I said, dont know and i won't know how many I need Can somebody help me? Grazie mille fin d'ora 
Thank you by now for answers |
Replies:
Posted By: rahulwalawalkar
Date Posted: 10 Jun 2009 at 2:23am
|
Hi
Will all records have the same structure
john AB eatapple
i.e Name AB sometext.....
so Will AB be there always in the Middle.....
if that's the case
Mid({Table.fieldname},Instr({Table.fieldname},"AB")+2)
cheers
Rahul
|
Posted By: nalfein
Date Posted: 10 Jun 2009 at 5:36am
|
Yeah I've tried and is good
Thank you |