Solved

Visio - 2010 - how to concatenate fields

Posted on 2013-11-21
2
1,127 Views
Last Modified: 2013-11-22
I'm trying to have my current filename AND it's current directory path appear in the same field.  How can I do this?
0
Comment
Question by:brothertruffle880
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
2 Comments
 
LVL 11

Assisted Solution

by:Visio_Guy
Visio_Guy earned 500 total points
ID: 39668170
Hi Bt,

You can do this one of two ways: insert two fields in the text of the shape, or use the custom formula field at the very bottom of the insert field dialog, left column.

You can insert multiple fields into the text of a shape. You just have to get into text-edit mode by double-clicking, selecting the shape and pressing F2, or using the text tool. Then you can place your cursor anywhere in the text and insert more fields. You can mix with hand-typed text as well.

Or you can make one big formula by choosing "Custom Formula" from the field list. Here's a big formula that labels and shows the directory and filename on two separate lines:

="Directory: " & DIRECTORY() & CHAR(10) & "Filename: " & FILENAME()

CHAR(10) is how you make a new line, and "&" is the concatenation operator.
0
 
LVL 11

Accepted Solution

by:
Visio_Guy earned 500 total points
ID: 39668171
Note that DIRCTORY() and FILENAME() and CHAR() are ShapeSheet functions. You have to know these functions (or at least guess a bit and let the intellisense help you) . There's no pick list for building custom formulas.
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article was inspired by a question here at Experts Exchange (http://www.experts-exchange.com/Software/Photos_Graphics/Images_and_Photos/Q_28629170.html). The requirements stated in that question are (1) reduce the file size of a large number of…
In a previous article here at Experts Exchange (http://www.experts-exchange.com/articles/18414/Create-a-PDF-file-with-Contact-Sheets-montage-of-thumbnails-for-all-JPG-files-in-a-folder-and-each-of-its-subfolders-using-an-automated-batch-method.html)…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Learn how to download your full Prezi presentation for offline presenting. Prezi doesn’t have to be viewed and shared in a web browser, even with a free account you can download your full presentation to share with others. Be sure to download any vi…

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question