按照字符拼音排序系统的建立与编辑实践

Establishment and editing practice of a new sorting system according to Chinese phonetic alphabet

将字符按照拼音排序经常会出现在图书和期刊的编委姓名排序、参考文献排序、索引排序等场景中。由于汉字多音字的存在,现有软件无法实现根据场景自动确定多音字的准确读音并排序,导致排序结果必须进行人工审核。而且,现有软件的排序规则通常无法更改。笔者利用VBA代码实现多音字读音的手动选择,依托Excel工作表输入待排序条目、设置排序规则,以及输出排序结果,实现了按照拼音排序含有多音字的条目,且排序规则可以自定义。本系统适合在编委姓名排序、参考文献排序、索引排序等多种场景下使用,普及性、通用性较强,能够提高编辑工作效率。同时文章也指出了系统存在的不足之处。

Sorting characters according to Chinese phonetic alphabets often appears in scenarios such as sorting the names of editorial board members,reference list,and index of books and journals.Due to polyphonic Chinese characters,existing software cannot automatically determine the accurate pronunciation and sorting of polyphonic characters based on scenarios,resulting in manual review of sorting results.Moreover,the sorting rules of existing software often cannot be changed.The author uses VBA code to manually select the pronunciation of polyphonic characters,relies on Excel worksheets to input the items to be sorted,set sorting rules,and output sorting results,and achieves sorting of items containing polyphonic characters according to Chinese phonetic alphabet.The sorting rule can be customized.This system is suitable for use in various scenarios such as editor name sorting,reference sorting,and index sorting.It has strong popularity and universality and can improve editing efficiency.At the same time,the article also pointed out the shortcomings of the system.