Crystal Reports Extract numbers froem a string

Technical Questions

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

Topic: Extract numbers froem a string

Post Reply

Post New Topic

Author	Message
maheedhar Newbie Joined: 04 Jul 2013 Location: India Online Status: Offline Posts: 1	Topic: Extract numbers froem a string Posted: 30 Aug 2013 at 8:50pm
	Hi, i have one string (WT 6.25/VT37.50/INV#3016617) from which i needs to take WT amount and Vat amount respectively. out put should be like this : WT=6.25 and VT=37.50. How should i get the desired out put. Thanks& Regards, Maheedhar
	IP Logged


praveeng Senior Member Joined: 11 Jul 2011 Online Status: Offline Posts: 165	Posted: 03 Sep 2013 at 1:23am
	Hi Maheedhar, We need to create two formulas to acheive your requirement, First one, name it as "WT", with the below logic StringVar WT:=Split((Database_Field,"/")[1]; Mid(WT,3,5) Second one, Name it as VT with the below logic StringVar VT:=Split((Database_Field,"/")[2]; Mid(VT,3,5) --Praveen G
	Praveen Guntuka, praveen_guntuka@yahoo.com
	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