Crystal Reports Splitting a String

Technical Questions

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

Topic: Splitting a String

Post Reply

Post New Topic

Author	Message
Pras Newbie Joined: 31 May 2011 Location: United Kingdom Online Status: Offline Posts: 6	Topic: Splitting a String Posted: 03 Jun 2011 at 6:06am
	Hi, I have a field "Client Name" in my database input as "London North (Client)". I would like the characters (Client) removed from my report of this field. Could you please suggest a way to get around this? Many thanks in advance. Pras
	IP Logged


FrnhtGLI Senior Member Joined: 22 May 2009 Online Status: Offline Posts: 347	Posted: 03 Jun 2011 at 6:17am
	left({@Client Name},instr({@Client Name},"(")-1)
	\|< /\ '][' ( )
	IP Logged

Pras Newbie Joined: 31 May 2011 Location: United Kingdom Online Status: Offline Posts: 6	Posted: 03 Jun 2011 at 7:57am
	Thanks a ton my friend!
	IP Logged

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