I'm required to create a rule to concatenate multiple fields. Between each
field I need to add a word space. I have tried several rules and have
achieved a 90% success. I am hoping for some help to complete the rule.
I have done the following:
Field("street") = 123 Main Street
Field("street2") = Suite 123
Field("city") = Anytown
.......
else
return Field("street") + ' ' + Field("street2") + ' ' +
Field("city");
and was returned: 123 Main StreetSuite 123Anytown
I have also tried:
.......
else
return Field("street") + ' ' + Field("street2") + ' ' +
Field("city");
and was returned: 123 Main Street Suite 123
I have also done this:
.......
else
return Field("street") + '^^ ' + Field("street2") + '^^ ' +
Field("city");
and was returned: 123 Main Street^^ Suite 123^^ Anytown
Any suggestions on how I could get just a single word space within my JS
rule. Your help will be greatly appreciated
Thanks,
Paul
--
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
--
