Crystal Reports Need help quickly with Trim question!!

Technical Questions
Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions

Topic: Need help quickly with Trim question!!

Author	Message
ChrisJ517 Newbie Joined: 21 May 2007 Online Status: Offline Posts: 16	Topic: Need help quickly with Trim question!! Posted: 30 May 2007 at 11:22am
	I have a string field that has certain data I need to extract. For example, every entry in the field looks like this: F/F (oc: Scott) DC (oc: Bob) Form Product (oc:Joe) Professional Services (oc: Bill) I need to know how I can get everything before the first ( to display on the report. Is this a Trim function? Please help!
	IP Logged

BrianBischof Admin Group Joined: 09 Nov 2006 Online Status: Offline Posts: 2458	Posted: 30 May 2007 at 2:05pm
	here you go. x := Left({table.field}, Instr({table.field},"(")-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 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.047 seconds.