Crystal Reports replace({myfield},"&",Chr(13))

Technical Questions

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

Topic: replace({myfield},"&",Chr(13))

Author	Message
swatts Groupie Joined: 17 Mar 2010 Online Status: Offline Posts: 83	Topic: replace({myfield},"&",Chr(13)) Posted: 30 Jan 2012 at 4:08am
	How do I get rid of the first one on this because with the Chr(13) it is blank?
	IP Logged


DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 30 Jan 2012 at 4:33am
	not understanding what you want to do here, can you explain further?
	IP Logged

swatts Groupie Joined: 17 Mar 2010 Online Status: Offline Posts: 83	Posted: 30 Jan 2012 at 4:42am
	My database has multiple selected data in it and to separate the data it uses &. &Mark&Jennifer&Steven&Roger& so I use replace ({namespace},"&",Chr(13)) but with the Chr(13) it starts it off with a blank because the is a leading &. How can I do away with the initial blank?
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 30 Jan 2012 at 4:54am
	Gotcha, replace(mid({namespace},2),"&",chr(13))
	IP Logged

swatts Groupie Joined: 17 Mar 2010 Online Status: Offline Posts: 83	Posted: 30 Jan 2012 at 5:03am
	Awesome! Worked like a charm! Thank you very much.
	IP Logged

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