I had this same problem a few weeks ago. Here is the reply I got at
that time. It worked for me.
Not a problem:
if(Right(Field("COMPANY NAME#"), 1) == "s")
return "’";
else
return "’s";
Put this rule after the company name field and make sure you check the
"Treat returned strings as tagged text" since this uses the entity for
the single quotation mark.
Bob McGuire
Variable Data Specialist
[EMAIL PROTECTED]
OPM Digital Print Services
10 Passan Drive - Bldg. 10
Laflin, PA 18702
Phone: 570-602-1315 FAX: 570-602-8813
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, March 12, 2007 8:37 AM
To: FusionPro Users Forum
Subject: [fusionpro] Re: Append ('s) to company name from csv file.
Correction. I want to append ('s) to company names and (') to companies
ending in s.
Example:
Acme Corp into Acme Corp's
and Jones Chemicals into Jones Chemicals'
--
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
--
Don't miss The Printable Technologies 2007 User Group Conference at the
Monte Carlo Resort and Casino in Las Vegas, March 14 through March 16,
2007.
For more details or to register, go to
http://www.traveltrust.com/Forms/pt_signup_2007-3.html
--
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
--
______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________
--
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
--
Don't miss The Printable Technologies 2007 User Group Conference at the Monte
Carlo Resort and Casino in Las Vegas, March 14 through March 16, 2007.
For more details or to register, go to
http://www.traveltrust.com/Forms/pt_signup_2007-3.html
--
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
--