You can simply use the Field function in place of the literal strings:
return Concatenate(", ", " or ",
Field("Vehicle1"), Field("Vehicle2"), Field("Vehicle3"));
Now, in your original message, you only mentioned that you were trying
to take some kind of arbitrary list of items and "list from one up to
eight items and separate them with a comma, but have the last two items
separated with the word 'or'." What I posted was a solution to that
general problem. If you're trying to do something more complex or
specific and only include certain items in the list based on some other
criteria, that's a separate problem, with possibly a different solution.
I'm not sure I completely understand what you're trying to do, though.
What are the field names and values you're comparing? Could you post
maybe the first two lines from your data file?
Dan
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
FusionPro 5.0 Now Available!
Variable text on a curve and soft drop-shadows for variable text
LIMITED TIME upgrade offer of $299 per license for current customers:
http://fusionpro.printable.com/store/upgrade
New licenses available for $599 each at:
http://fusionpro.printable.com/store/
All FusionPro 5.0 customers to receive FusionPro 5.1 with
Adobe Acrobat 8 and InDesign CS3 support when released for FREE.
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
--
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
--
