Kim,
You can use a split function like this:

offerformat = Field("Offer");
a = offerformat.split("%");
return a[0]


This uses the % symbol as a split character. By returning a[0] you are
returning the 1st value of the split. If you return a[1] you would get what
is in the 2nd position of the split. In this case you would get the word
'Off'.


Doug Pershing
VP-Data & Production
WMSG Inc
1278 Titan Dr
Dallas, TX 75247
(214) 640-2224
e-mail [EMAIL PROTECTED]
web http://wmsginc.com
click on information and news to see the latest at WMSG Inc.



-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Thursday, July 05, 2007 12:46 PM
To: FusionPro Users Forum
Subject: [fusionpro] strip info from field

So, now I have a question about replacing or stripping info.

I have a field that contains data such as 5% Off, 15% Off, 20% Off, etc. 

I would like to parse out just the number. I know I can get rid of the %
with this:

percentvar=Field("Offer")

percentvar=percentvar.replace("%", "")

but I don't know how or if it's possible to add to the above so that I
could strip out the Off as well?

thanks,
kim

+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+- 
Calling all FP Web Users!

Do you have a question or lots of knowledge to share about FusionPro Web?

If so, join our Printable Web to Print Users' Forum today!

Send email to [EMAIL PROTECTED] to find out how! 
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-


--

Users of FusionPro Desktop have unlimited free email support. Contact
Printable Support at [EMAIL PROTECTED] 
--

View FusionPro Knowledge Base, FusionPro Samples at
www.printable.com/vdp/desktop.htm

--

To unsubscribe send a blank email to [EMAIL PROTECTED]
--


--

--




+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+- 
Calling all FP Web Users!

Do you have a question or lots of knowledge to share about FusionPro Web?

If so, join our Printable Web to Print Users' Forum today!

Send email to [EMAIL PROTECTED] to find out how! 
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-


--
Users of FusionPro Desktop have unlimited free email support. Contact Printable 
Support at [EMAIL PROTECTED] 
--
View FusionPro Knowledge Base, FusionPro Samples at
www.printable.com/vdp/desktop.htm

--
You are currently subscribed to fusionpro as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
--


--
Note:  All e-mail sent to or from this address will be received or otherwise 
recorded by the e-mail recipients of this forum. It is subject to archival, 
monitoring or review by, and/or disclosure to someone other than the recipient. 
Our privacy policy is posted on www.printplanet.com
--

Reply via email to