Crystal Reports split field

Tips and Tricks
Crystal Reports Forum : Crystal Reports 9 through 2022 : Tips and Tricks

Topic: split field

Author	Message
natali Newbie Joined: 15 Jan 2013 Online Status: Offline Posts: 26	Topic: split field Posted: 15 Jan 2013 at 6:03am
	How can I split a field {GenMaster.GlCode}? it looks like that 25-000-11-724 thx
	IP Logged

lolly54 Groupie Joined: 25 Sep 2011 Online Status: Offline Posts: 58	Posted: 15 Jan 2013 at 1:51pm
	You can use the left, right, and mid functions. :) 25 --> left({GenMaster.GlCode}, 2) 000 --> mid({GenMaster.GlCode},4, 3) 11 --> mid ({GenMaster.GlCode},8, 2) 724 --> right ({GenMaster.GlCode},3) Hope these help... :)
	IP Logged

natali Newbie Joined: 15 Jan 2013 Online Status: Offline Posts: 26	Posted: 16 Jan 2013 at 3:38am
	Thank you very much Lolly, I tried it. But last three lines were highlighted and I got this message: The remaining text does not appear to be part of the formula. Then I entered each line as a separate formula and it worked.
	IP Logged

lolly54 Groupie Joined: 25 Sep 2011 Online Status: Offline Posts: 58	Posted: 16 Jan 2013 at 12:40pm
	Yea, Natali, they are four different formula. Glad it worked!
	IP Logged

natali Newbie Joined: 15 Jan 2013 Online Status: Offline Posts: 26	Posted: 17 Jan 2013 at 3:28am
	Thank you again. It helped me a lot.
	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.023 seconds.