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
--