Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Trim Left (I think) / Finding Text in a field??? Post Reply Post New Topic
<< Prev Page  of 2
Author Message
motoxracer400f
Newbie
Newbie
Avatar

Joined: 11 Sep 2007
Location: United States
Online Status: Offline
Posts: 27
Quote motoxracer400f Replybullet Posted: 05 Mar 2008 at 7:39am
Thanks guys, I'm getting closer (using the code above), but I still don't know what is happening.  I am putting the above code in the "Display String" field of the text box in green.  SEE THE LINK BELOW
 
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: 05 Mar 2008 at 10:59am
Hi,
 
Can you email me the data in the field to rahulwalawalkar@gmail.com
 
cheers
rahuk
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 05 Mar 2008 at 11:28am
The problem is that when the formula searches for the first chr(13), it doesn't take into account where the FOLLOWUPS: string is located. It needs to be modified so that it starts searching for the chr(13) after Followups. Thus, you need to embed the Instr() function within another Instr() function. I cleaned up the code by adding a variable. (I might be missing a parentheses, but I think its okay).

NumberVar FollowUpsLoc;
FollowUpsLoc := Instr({table.fieldname}, 'FOLLOWUPS:');
IF FollowUpsLoc > 0 then
Mid ({Table.FieldName} , Instr(FollowUpsLoc, {Table.FieldName} ,chr(13))+1)



Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
IP IP Logged
motoxracer400f
Newbie
Newbie
Avatar

Joined: 11 Sep 2007
Location: United States
Online Status: Offline
Posts: 27
Quote motoxracer400f Replybullet Posted: 05 Mar 2008 at 11:41am

Clap Works like a charm!!!  Thanks guys!!!!

IP IP Logged
<< Prev Page  of 2
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.031 seconds.