Crystal Reports Special char

Announcements
Crystal Reports Forum : General Information : Announcements

Topic: Special char

Author	Message
patil Newbie Joined: 19 Apr 2010 Online Status: Offline Posts: 16	Topic: Special char Posted: 09 Jun 2010 at 12:26am
	Hi All, in my report one column is ther i.e. phone number=1234567898 i want answer in my report as: phone number=123-456-7898 how to get this answer... plz help me out ASAP
	IP Logged

rahulwalawalkar Senior Member Joined: 08 Jun 2007 Location: United Kingdom Online Status: Offline Posts: 731	Posted: 09 Jun 2010 at 1:57am
	Hi Create the following formulas 1) Left3- left(replace(cstr({@char}),',',''),3)+'-' 2)Mid3- replace(Mid(cstr({@char}),5,4),',','')+'-' 3)Right4- Mid(replace(cstr({@char}),',',''),7,4) 4)Combine trim({@Left3-} +{@Mid3-}+{@Right4-}) Replace @char with your {table.phonenumberfield} Cheers Rahul
	IP Logged

patil Newbie Joined: 19 Apr 2010 Online Status: Offline Posts: 16	Posted: 09 Jun 2010 at 5:47pm
	Thank you so much... its works...
	IP Logged

patil Newbie Joined: 19 Apr 2010 Online Status: Offline Posts: 16	Posted: 11 Jun 2010 at 1:26am
	but i want all these 4 formulas to be written in one formula... how to do???
	IP Logged

kevlray Admin Group Joined: 29 Oct 2009 Online Status: Offline Posts: 1587	Posted: 11 Jun 2010 at 5:25am
	Expand each one of the formulas into the last statement. trim(left(replace(cstr({@char}),',',"),3+"-"+replace(Mid...., etc. Hard to read, but possible.
	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.016 seconds.