Zephyr Style Advisor
Help Suggestions, Questions & Comments Zephyr Site Map
  Dynamic Text  

Online Support Session

Frequently Asked Questions

Documentation

StyleADVISOR Statistics

AllocationADVISOR Statistics

Tips & Hints

Database Descriptions

Quick Tip Videos

Dynamic Text


Below is a list of Dynamic Text reference materials with details about what they provide. To view these references simply click on the link for the desired document and in the dialog that pops up either open or save to disk. Some of the documents are PDF files which open with Adobe Acrobat.

Reference Format Date Size
Getting Started with Dynamic Text PDF (Adobe Acrobat) 11/01/2006 430 Kb
  • This document provides an essential starting point for using Dynamic Text. It covers the basic Dynamic Text code structure, exporting StyleADVISOR charts to Graph Rectangles in a Microsoft Office document, and exporting specific StyleADVISOR values to a Microsoft Office document that contains Dynamic Text.
Sample Dynamic Text ZSA (StyleADVISOR) 11/01/2006 305 Kb
  • This StyleADVISOR workbook contains sample Dynamic Text and illustrates incorporating Dynamic Text directly into a StyleADVISOR workbook. It focuses on customizing titles and changing information displayed in a StyleADVISOR workbook. Additionally, all of the code in this workbook can be copied and pasted directly into another StyleADVISOR workbook.
  • Download the zipped file here.
Dynamic Text Code Bank XLS (Excel) 11/01/2006 93 Kb
  • This Excel spreadsheet contains dynamic text code examples to pull information from a standard StyleADVISOR Manager Analysis workbook. Each of the Excel worksheets contains the StyleADVISOR table name, unformatted dynamic text code, formatted dynamic text code, and a sample of the formatted output. All of the dynamic text (formatted or unformatted) can be copied and used as it is, provided the code is used in conjunction with a standard StyleADVISOR Manager Analysis workbook for exporting.
Number Formatting in Dynamic Text PDF (Adobe Acrobat) 03/26/2008 56 Kb
  • This document provides information on the different methods of formatting numbers in Dynamic Text. It details examples of the formatting variables, including trailing digits, leading digits, thousand, and percent. It also addresses setting default number formatting for all Dynamic Text in a StyleADVISOR workbook.
Date Formatting in Dynamic Text PDF (Adobe Acrobat) 03/26/2008 54 Kb
  • This document provides information on the different methods of formatting dates in Dynamic Text. It covers examples of the formatting variables, including day, month, quarter, and year time periods. It also includes examples of ordinal dates (2nd, 3rd, 4th) and setting default date formatting for all Dynamic Text in a StyleADVISOR workbook.
Debugging Dynamic Text PDF (Adobe Acrobat) 11/01/2006 48 Kb
  • This document provides several different methods and techniques for debugging Dynamic Text issues. It is an invaluable reference for troubleshooting Dynamic Text problems. It highlights simplifying code, displaying additional information, hardcoding variables, and checking data types and data lengths.
Workbook Functions in Dynamic Text PDF (Adobe Acrobat) 01/18/2008 57 Kb
  • This document covers the exceptionally powerful Dynamic Text tool Workbook Functions. It details what workbook functions are, how they are used, how and why to write them, and finally how to best implement them. If your Dynamic Text code has moved beyond pulling statistics with Value(), this document will be invaluable for simplifying your work.
String Manipulation in Dynamic Text PDF (Adobe Acrobat) 03/26/2008 62 Kb
  • This document provides information on the different methods of manipulating strings in Dynamic Text. It highlights and shows detailed examples of Find, Replace, and Concatenation, and covers some of the lesser used DT manipulation functions including Length, WrapText, and Combine. It also includes an example of how to make code that can handle mixed case characters.
Conditional Logic in Dynamic Text
PDF (Adobe Acrobat) 01/18/2008 39 Kb
  • This document addresses conditional logic, also known as If/Then statements. It starts with the basics and simple examples, then builds to complicated tests. Conditional logic is a tool that every DT user needs to understand and have in their tool box.
Looping in Dynamic Text PDF (Adobe Acrobat) 01/18/2008 34 Kb
  • This document gets to the heart of the three ways to create loops in Dynamic Text; For, While, and Repeat Until. It also provides detailed working examples of each.
Writing Readable Dynamic Text PDF (Adobe Acrobat) 01/18/2008 60 Kb
  • This document provides some "best practices" for writing Dynamic Text code. One of the major complications with code (for any programming language) is making it legible for others. As important is making it fully understandable to yourself should you need to revisit it several months or years later. This documents offers some suggestions to avoid common pitfalls in this area. It address commenting, spacing, formatting, naming, and many other very useful suggestions. It's a must read for any DT "programmer!"
Dynamic Text with Excel PDF (Adobe Acrobat) 11/01/2006 48 Kb
  • This document covers using Dynamic Text in StyleADVISOR to reference information from an Excel spreadsheet. It provides an example of pulling Top 10 Holdings information from Excel into a StyleADVISOR workbook.

 

 
Copyright Zephyr Associates, Inc. 1995 - 2008
Product & Data Updates Zephyr Support Zephyr Company Info Zephyr Training Resources Zephyr Products Zephyr Home