Crystal Reports Contains * in text string formula

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

Topic: Contains * in text string formula

Author	Message
grego Newbie Joined: 22 Feb 2008 Location: United Kingdom Online Status: Offline Posts: 16	*Topic: Contains in text string formula** Posted: 22 Feb 2008 at 2:21am
	I am trying to write a formula in Crystal 10 that only returns a text string when that text string contains the * character. Any ideas on what syntax I should be using? thanks
	IP Logged

hilfy Admin Group Joined: 20 Nov 2006 Online Status: Offline Posts: 3702	Posted: 22 Feb 2008 at 6:57am
	Try using this formula: If InStr({table.field}, '*') > 0 then {table.field} -Dell
	Proviti, Data & Analytics Practice www.protiviti.com/US-en/data-management-advanced-analytics
	IP Logged

grego Newbie Joined: 22 Feb 2008 Location: United Kingdom Online Status: Offline Posts: 16	Posted: 25 Feb 2008 at 2:26am
	it worked perfectly - thank you so much - you've saved me hours!
	IP Logged

Gurbs Senior Member Joined: 16 Feb 2012 Location: Ireland Online Status: Offline Posts: 216	Posted: 14 Mar 2012 at 1:27am
	I want just the opposite of this, I want to exclude everything containing a *. How can I modify the formula for this?
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 14 Mar 2012 at 3:49am
	InStr({table.field}, '*') = 0 Edited by DBlank - 14 Mar 2012 at 3:50am
	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.031 seconds.