Crystal Reports Phone Number Field Help

Technical Questions

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

Topic: Phone Number Field Help

Post Reply

Post New Topic

Author	Message
skreczko Newbie Joined: 18 Oct 2010 Online Status: Offline Posts: 7	Topic: Phone Number Field Help Posted: 17 Nov 2010 at 7:45am
	Hello CR Gods, I have a phone number field with multiple formats. See Sample. I need it in a standards (XXX)XXX-XXXX format. Does anyone know how to do this. ALSO, the field is in String Format. Sample Phone Field (262) 965-2356 262-392-2837 (262) 224-7681cell 414-704-6690cell Thanks
	IP Logged


FrnhtGLI Senior Member Joined: 22 May 2009 Online Status: Offline Posts: 347	Posted: 17 Nov 2010 at 10:23am
	It's not pretty, but: picture(replace(replace(replace(replace(replace({table.telephonefield},'(',''),')',''),' ',''),'-',''),'cell',''), '(XXX)XXX-XXXX')
	\|< /\ '][' ( )
	IP Logged

skreczko Newbie Joined: 18 Oct 2010 Online Status: Offline Posts: 7	Posted: 17 Nov 2010 at 10:28am
	IT WORKED!!!! It's so ugly it's beautiful. Like a PUG!! thanks
	IP Logged

mivre Newbie Joined: 02 May 2011 Online Status: Offline Posts: 1	Posted: 02 May 2011 at 5:26pm
	It's so ugly it's beautiful
	best laser pointer st tmart online shopping
	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