Crystal Reports Formula to select part of table

Report Design

Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design

Topic: Formula to select part of table

Post Reply

Post New Topic

Author	Message
Rodemusprime Newbie Joined: 19 Aug 2010 Online Status: Offline Posts: 10	Topic: Formula to select part of table Posted: 19 Aug 2010 at 3:28am
	Hello everyone. I'm new to CR, and my needs are not so much financial, but more in creating directories. I have a record that reads something like this HOSPITAL/DERMATOLOGY/USERNAME Is there a way to just print what is between the 2 slashes alone?
	IP Logged


DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 19 Aug 2010 at 3:41am
	mid({field},instr({field},'/')+1,(instrrev({field},'/')-1)-instr({field},'/'))
	IP Logged

Rodemusprime Newbie Joined: 19 Aug 2010 Online Status: Offline Posts: 10	Posted: 22 Sep 2010 at 6:14am
	Dblank, that helped a lot. Thank you very much.
	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