Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Partial Print Post Reply Post New Topic
Author Message
nalfein
Groupie
Groupie


Joined: 07 Jul 2008
Online Status: Offline
Posts: 47
Quote nalfein Replybullet Topic: Partial Print
    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
IP IP Logged
rahulwalawalkar
Senior Member
Senior Member
Avatar

Joined: 08 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 731
Quote rahulwalawalkar Replybullet 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


Edited by rahulwalawalkar - 10 Jun 2009 at 2:38am
IP IP Logged
nalfein
Groupie
Groupie


Joined: 07 Jul 2008
Online Status: Offline
Posts: 47
Quote nalfein Replybullet Posted: 10 Jun 2009 at 5:36am
Yeah I've tried and is good

Thank you
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.029 seconds.