When converting a termbase to Excel, It has to be flattened, so all the information can be stored in a 2-dimensional spreadsheet. In several places, this is achieved by separators. That is, you take a list of data items, and write them into once cell, separated by a specific delimiter. This is the case for:

  • Synonyms of a term, by default like this: Term|Synonym
  • Multiple Instances of a field, by default like this: Comment oneComment 2
  • Selected Picklist values, by default like this: legal,financial


You can use multiple characters, including whitespace, to make your spreadsheet more readable. Just keep in mind, if you share your data with other converter users, they need the same settings. Note: earlier versions just allowed a single character here/


Separator Rules

  1. Separators can consist of any number of characters
  2. They can contain line breaks and tabs, by adding \n or \t. For example synonyms can look better with this separator: |\n. (Technical note: \n actually also covers \r\n, and the converter will write \r\n into a spreadsheet. If you really only want \n, see rule 4.)
  3. Leading and trailing whitespace are ignored. So if you type ", " (comma and blank), the trailing blank will disappear and leave you with just the comma. There is a workaround for this:
  4. You can add characters by their hexadecimal Unicode value. This can be in a 2-digit format marked by \x, or a 4-digit format marked by \u. For example a blank would be \x20, a newline is \x0A, and the double pipe used for multiple fields, , is \u2016.

Created with the Personal Edition of HelpNDoc: Easily create iPhone documentation