TABLE OF CONTENTS 1. AUTOMATED REORGANIZATION OF LIST FILE AND CREATION OF INDEXED VERSION 1. 1.1 Introduction 1.1 2. DEMO CASE, Customer Relationship Management (CRM) 2. 3. CREATION OF CHAPTERS AND SUBCHAPTERS 3. 3.1 Marking of chapters 3.1 3.2 stand-alone chapter structure demo: 3.2 3.3 Proposal for creating the first chapter 3.3 3.4 Save as UTF-8 3.4 4. OUTPUT FILES 4. 4.1 Reformated *.txt file 4.1 4.2 Reformated *.htm file 4.2 4.3 Reformated and indexed *.htm file 4.3 4.4 Reformated *.csv file 4.4 5. NUMBERING AND RENUMBERING OF CHAPTERS 5. 6. CONVERSION TO HTML FORMAT AND INDEXING 6. 7. USING THE PROGRAM FOR SUMMARIZING BY GROUPS IN EXCEL COMPATIBLE TABLES 7. 7.1 Summarization by groups, program sumif_01 7.1 8. INFO 8.
Date of last change (yyyy-mm-dd): 2025.08.03 1. AUTOMATED REORGANIZATION OF LIST FILE AND CREATION OF INDEXED VERSION 1.1 Introduction The program enables efficient maintenance of various lists, provided that all records in one file have the same structure. The structure of the file is determined by the numbering of chapters and subchapters. Entering data is very easy, as it is completed as a TXT file. At each launch, the program updates and reconfigures the entire file, and if necessary, also indexes the content word by word. The HTML file is indexed throughout the content and allows full-text search. The all-words index file is accessible while reading, just by double-clicking on any word. look_at: 6. 2. DEMO CASE, Customer Relationship Management (CRM) The demo example contains several files that demonstrate the process of list creation, completion and sorting. The demo example also includes the use of one of our programs, which facilitates work with EXCEL compatible tables. Demo files and programs are available at: http://www.txt-utilities.com/txt-list/demo-crm/demo-crm.7z 3. CREATION OF CHAPTERS AND SUBCHAPTERS Creating a list begins with creating the structure of an independent chapter. All records (chapters) in the file will have the same structure but different content. Chapters are marked exclusively by multilevel numbering. The format of this numbering is n1.n2.n3 ... 3.1 Marking of chapters The chapters on the first level are marked n1. , a dot at the end is mandatory. The chapters of the second level are marked n1.n2, the third level n1.n2.n3 and so on. There is no dot for the last chapter numeric code, code n1.n2.n3. is wrong. The correct chapter designation on the third level is therefore n1.n2.n3 , without a dot at the end. The chapter label is followed by one or more spaces and the title of the chapter. The content of the chapter is written in the following lines under the chapter mark. The content of the chapter on the left edge is aligned with the chapter mark. Long lines of text are not printed separately, so they are not recommended. 3.2 stand-alone chapter structure demo: - 1. chapter - 1.1 subchapter - 1.2 subchapter - 1.2.1 subchapter - 1.3 subchapter - 1.4 subchapter - ..... 3.3 Proposal for creating the first chapter The chapter with the "*" character in the title will be positioned at the beginning of the file after sorting, so we suggest that you use such a chapter for the initial creation of the chapter. When entering data, use the Copy Paste options and rename it accordingly. - 1. * chapter - 1.1 * subchapter - 1.2 * subchapter - 1.2.1 * subchapter - 1.3 * subchapter - 1.4 * subchapter - ..... Since the program groups chapters by chapter tag at the first (1st) level, all chapters belonging to one group must have the same, but unique chapter tag at the 1st level. Therefore, in the demo files, we added a unique tag id=... to the chapters at the 1st level. However, this could be any alphanumeric string. 3.4 Save as UTF-8 The file must have at least one blank line at the beginning. Save as UTF-8 code page. You must save the list TXT file in the UTF-8 code page, which later ensures that all characters are printed correctly. Look demo file: http://www.txt-utilities.com/txt-list/demo-crm/demo.txt 4. OUTPUT FILES After starting the program and selecting the input file (*.txt), the program will create 4 output files. 4.1 Reformated *.txt file The reformatted file file.name_YYYY_MM_DD_hh_mm_ss.txt is the most important output file. Chapters are sorted by title and renumbered. 4.2 Reformated *.htm file The reformatted file file.name_YYYY_MM_DD_hh_mm_ss.htm is the output file with the most friendly format. It is basically an output file file.name_YYYY_MM_DD_hh_mm_ss.txt in HTML format. 4.3 Reformated and indexed *.htm file An indexed *.htm file is indexed using the htm_ndx_*.exe program, and the result is accessible in the /htm_ndx/htm_out subdirectory. The all-words index file is accessible while reading, just by double-clicking on any word. 4.4 Reformated *.csv file The reformatted file file.name_YYYY_MM_DD_mm_ss.csv is an output file with EXCEL compatible format (*.CSV). The file is especially useful when we also have numerical input data and want to perform additional tabular calculations. 5. NUMBERING AND RENUMBERING OF CHAPTERS The essential functionality of the program is to renumber the chapters by levels and indent them accordingly. The program first sorts the chapters by titles, and then renumbers them in sorted order. Therefore, the initial numbering of the chapter and sub-chapters is not important, but it is important that the numbering used reflects the required same structure for all the chapters in the list. When adding a new chapter, all chapters can therefore start with the numbering 1. If the new chapter is added at the beginning of the list, after reorganization it will be at the beginning of a group of chapters with the same title, but if it is added at the end of the list, it will be placed at the end of the corresponding group of chapters. 6. CONVERSION TO HTML FORMAT AND INDEXING At the same time as creating a new TXT file structure, the program also creates an HTML output file. The HTML output list file can also be indexed at the same time. The indexed HTML file is programmatically renamed and copied to the HTM_NDX/HTM_OUT subfolder. Indexing an HTML file is optional and is performed by the EXTERNAL program htm_ndx_*.exe. Remember: the all-words index file is accessible while reading, just by double-clicking on any word. The indexed version of demo file is available at: http://www.txt-utilities.com/txt-list/demo-crm/htm_ndx/htm_out/page_1.htm 7. USING THE PROGRAM FOR SUMMARIZING BY GROUPS IN EXCEL COMPATIBLE TABLES One of the output tables is in Excel compatible format (*.csv) and is adapted for further calculations. In our case, we wanted to find out the summation by groups, and for this purpose we used one of our programs, which makes the work much easier. 7.1 Summarization by groups, program sumif_01 The program generates Excel formulas that just need to be copied into a table. For the needs of our demo list, the program created the file efg_sumif_01.htm, which contains formulas. We copied these formulas into an Excel compatible file file.name_YYYY_MM_DD_mm_ss.csv, supplemented them a little in one column and performed the calculation. For easier traceability of the described process, the formulas are also written in the file demo_sumif_01_formulas.csv The program sumif_01_*.exe is included in demo-crm.7z The program is easy to use, but it is still necessary to see demo examples in order to know how to use it independently. Program sumif_01: http://www.utilities4promoting.com/calc-utilities/index.htm http://www.utilities4promoting.com/calc-utilities/sumif_01/sumif_01.7z 8. INFO http://www.txt-utilities.com/txt-list/index.htm
This document was structured using the TXT-INDENT program.
More info: www.utilities4promoting.com