Performs various useful functions with lists of data, including all of the following: sort, filter, output, merge into templates to generate output text files (such as HTML), merge multiple files into one, combine records with duplicate keys.
Version: 6.20PSTextMerge merges lists of data into text templates to create fully populated text files. The output files can be Web pages, XML files, RSS Feeds or any other varieties of text files.
Operating System: Windows
The input data can be obtained from a tab-delimited data file, or directly from a Microsoft Excel spreadsheet, or from a variety of other formats. You can record and easily play back recorded scripts, making it easy to re-generate your output text files when your data changes.
Tab-delimited files can be easily exported from most spreadsheets, databases, address book, and many other programs.
Version 3.4: Converted to freeware; added ability to truncate data on the left of a variable.
Version 3.3: Added several new filter operands for text, to test whether one string starts with another, ends with another, or does not. Also changed format of Last Mod Date, for directory listings, to use hyphens rather than slashes as separators. Also added ability to create output directories for output files, rather than forcing user to create these in advance.
Version 3.2: Added INCLUDE, IFNEWLIST and IFENDLIST commands to template processing. Added ability to extract hyperlinks from Excel spreadsheet cells, and to output fully formed table rows from Excel spreadsheets, using both the content and format of the Excel cells to generate the appropriate HTML table data cells.
Version 3.1: Added a Play Recent Scripts menu which will remember most recent scripts played. Added support for a central templates library. Added new input text format for outlining.