一个热爱网络的小学教师

Excel中汉字转拼音的实现

重要更新:加删除线的代码实测不能完美转换拼音,请参考后面那段没有加删除线的代码。注意,代码转换出来的拼音是没有调号的,如果需要转换出来的拼音加上调号,请参考下面这个地址:http://www.excelpx.com/thread-178363-1-1.html。

最近弄档案,需要将Excel表格中的所有人名转换为拼音,而Excel没有拼音函数,如果表格中人数较少,比如只有十来个,这样可以手动输入拼音,但我这个Excel表格人数太多了,足足1000多人,手动输入很不现实,所以最好的办法就是使用拼音函数来完成。

度娘搜索之后打开排在最前面的几个结果,发现都不靠谱,如这两个:

http://zhidao.baidu.com/link?url=NPL6M7NUWvvDRNoBQBYGc23bv0Fe2LCxX_BMy6U8WYrVx07sBRpiuFwzlOi8creNkPsURbVVvYpPOhFOOGqzfq

http://wenku.baidu.com/view/e99675134431b90d6c85c78a.html

都不能完美实现汉字转拼音,要么只有声母,要么就是转换不全,后来换bing搜索,终于找到一个靠谱的(抱歉,我又在不知不觉黑度娘了,呵呵,谁叫他的结果那么不靠谱呢):

http://blog.sina.com.cn/s/blog_515aa9780100qbkl.html(实测此代码不能完美转换)

试用之后我发现这个拼音函数可以很好的对姓名进行批量转换,表格中的1000多个人名完全转换,不存在转换不完全的现象,当然姓名中的多音字需要具体情况具体分析,毕竟程序又不是人。使用方法见下:

一、首先输入代码:

(1)打开电子表格软件;

(2)执行工具-宏- VISUAL BASIC编辑器;

(3)插入-模块;

(4)在模块中输入相关代码;

(5)关闭VB编辑器;

二、函数的使用

例如:在A1单元格中有姓名:郑兴民,想在A2单元格中显示拼音”zheng xing min”,只需要在A2单元格中输入“=pinyin(a1)”,再按回车键。

附函数代码:
Function PinYin(Hz As String)
Dim PinMa As String
Dim MyPinMa As Variant
Dim Temp As Integer, i As Integer, j As Integer
PinMa = “a,20319,ai,20317,an,20304,ang,20295,ao,20292,”
PinMa = PinMa & “ba,20283,bai,20265,ban,20257,bang,20242,bao,20230,bei,20051,ben,20036,beng,20032,bi,20026,bian,20002,biao,19990,bie,19986,bin,19982,bing,19976,bo,19805,bu,19784,”
PinMa = PinMa & “ca,19775,cai,19774,can,19763,cang,19756,cao,19751,ce,19746,ceng,19741,cha,19739,chai,19728,chan,19725,chang,19715,chao,19540,che,19531,chen,19525,cheng,19515,chi,19500,chong,19484,chou,19479,chu,19467,chuai,19289,chuan,19288,chuang,19281,chui,19275,chun,19270,chuo,19263,ci,19261,cong,19249,cou,19243,cu,19242,cuan,19238,cui,19235,cun,19227,cuo,19224,”
PinMa = PinMa & “da,19218,dai,19212,dan,19038,dang,19023,dao,19018,de,19006,deng,19003,di,18996,dian,18977,diao,18961,die,18952,ding,18783,diu,18774,dong,18773,dou,18763,du,18756,duan,18741,dui,18735,dun,18731,duo,18722,”
PinMa = PinMa & “e,18710,en,18697,er,18696,”
PinMa = PinMa & “fa,18526,fan,18518,fang,18501,fei,18490,fen,18478,feng,18463,fo,18448,fou,18447,fu,18446,”
PinMa = PinMa & “ga,18239,gai,18237,gan,18231,gang,18220,gao,18211,ge,18201,gei,18184,gen,18183,geng,18181,gong,18012,gou,17997,gu,17988,gua,17970,guai,17964,guan,17961,guang,17950,gui,17947,gun,17931,guo,17928,”
PinMa = PinMa & “ha,17922,hai,17759,han,17752,hang,17733,hao,17730,he,17721,hei,17703,hen,17701,heng,17697,hong,17692,hou,17683,hu,17676,hua,17496,huai,17487,huan,17482,huang,17468,hui,17454,hun,17433,huo,17427,”
PinMa = PinMa & “ji,17417,jia,17202,jian,17185,jiang,16983,jiao,16970,jie,16942,jin,16915,jing,16733,jiong,16708,jiu,16706,ju,16689,juan,16664,jue,16657,jun,16647,”
PinMa = PinMa & “ka,16474,kai,16470,kan,16465,kang,16459,kao,16452,ke,16448,ken,16433,keng,16429,kong,16427,kou,16423,ku,16419,kua,16412,kuai,16407,kuan,16403,kuang,16401,kui,16393,kun,16220,kuo,16216,”
PinMa = PinMa & “la,16212,lai,16205,lan,16202,lang,16187,lao,16180,le,16171,lei,16169,leng,16158,li,16155,lia,15959,lian,15958,liang,15944,liao,15933,lie,15920,lin,15915,ling,15903,liu,15889,long,15878,lou,15707,lu,15701,lv,15681,luan,15667,lue,15661,lun,15659,luo,15652,”
PinMa = PinMa & “ma,15640,mai,15631,man,15625,mang,15454,mao,15448,me,15436,mei,15435,men,15419,meng,15416,mi,15408,mian,15394,miao,15385,mie,15377,min,15375,ming,15369,miu,15363,mo,15362,mou,15183,mu,15180,”
PinMa = PinMa & “na,15165,nai,15158,nan,15153,nang,15150,nao,15149,ne,15144,nei,15143,nen,15141,neng,15140,ni,15139,nian,15128,niang,15121,niao,15119,nie,15117,nin,15110,ning,15109,niu,14941,nong,14937,nu,14933,nv,14930,nuan,14929,nue,14928,nuo,14926,”
PinMa = PinMa & “o,14922,ou,14921,”
PinMa = PinMa & “pa,14914,pai,14908,pan,14902,pang,14894,pao,14889,pei,14882,pen,14873,peng,14871,pi,14857,pian,14678,piao,14674,pie,14670,pin,14668,ping,14663,po,14654,pu,14645,”
PinMa = PinMa & “qi,14630,qia,14594,qian,14429,qiang,14407,qiao,14399,qie,14384,qin,14379,qing,14368,qiong,14355,qiu,14353,qu,14345,quan,14170,que,14159,qun,14151,”
PinMa = PinMa & “ran,14149,rang,14145,rao,14140,re,14137,ren,14135,reng,14125,ri,14123,rong,14122,rou,14112,ru,14109,ruan,14099,rui,14097,run,14094,ruo,14092,”
PinMa = PinMa & “sa,14090,sai,14087,san,14083,sang,13917,sao,13914,se,13910,sen,13907,seng,13906,sha,13905,shai,13896,shan,13894,shang,13878,shao,13870,she,13859,shen,13847,sheng,13831,shi,13658,shou,13611,shu,13601,shua,13406,shuai,13404,shuan,13400,shuang,13398,shui,13395,shun,13391,shuo,13387,si,13383,song,13367,sou,13359,su,13356,suan,13343,sui,13340,sun,13329,suo,13326,”
PinMa = PinMa & “ta,13318,tai,13147,tan,13138,tang,13120,tao,13107,te,13096,teng,13095,ti,13091,tian,13076,tiao,13068,tie,13063,ting,13060,tong,12888,tou,12875,tu,12871,tuan,12860,tui,12858,tun,12852,tuo,12849,”
PinMa = PinMa & “wa,12838,wai,12831,wan,12829,wang,12812,wei,12802,wen,12607,weng,12597,wo,12594,wu,12585,”
PinMa = PinMa & “xi,12556,xia,12359,xian,12346,xiang,12320,xiao,12300,xie,12120,xin,12099,xing,12089,xiong,12074,xiu,12067,xu,12058,xuan,12039,xue,11867,xun,11861,”
PinMa = PinMa & “ya,11847,yan,11831,yang,11798,yao,11781,ye,11604,yi,11589,yin,11536,ying,11358,yo,11340,yong,11339,you,11324,yu,11303,yuan,11097,yue,11077,yun,11067,”
PinMa = PinMa & “za,11055,zai,11052,zan,11045,zang,11041,zao,11038,ze,11024,zei,11020,zen,11019,zeng,11018,zha,11014,zhai,10838,zhan,10832,zhang,10815,zhao,10800,zhe,10790,zhen,10780,zheng,10764,zhi,10587,zhong,10544,zhou,10533,zhu,10519,zhua,10331,zhuai,10329,zhuan,10328,zhuang,10322,zhui,10315,zhun,10309,zhuo,10307,zi,10296,zong,10281,zou,10274,zu,10270,zuan,10262,zui,10260,zun,10256,zuo,10254”
MyPinMa = Split(PinMa, “,”)
For i = 1 To Len(Hz)
Temp = Asc(Mid(Hz, i, 1))
If Temp < 0 Then
Temp = Abs(Temp)
For j = 791 To 1 Step -2
If Temp


更改的代码(亲测可用):

Public PY_DB(1 To 72, 1 To 94) As String
Public PY_Index() As Integer
Sub DealVal_1()
    Dim i As Integer, j As Integer
    Dim Db As Variant
    Dim PYDB(72) As String
    PYDB(0) = "-2050,-2306,-2562,-2818,-3074,-3330,-3586,-3842,-4098,-4354,-4610,-4866,-5122,-5378,-5634,-5890,-6146,-6402,-6658,-6914,-7170,-7426,-7682,-7938,-8194,-8450,-8706,-8962,-9218,-9474,-9730,-9986,-10247,-10498,-10754,-11010,-11266,-11522,-11778,-12034,-12290,-12546,-12802,-13058,-13314,-13570,-13826,-14082,-14338,-14594,-14850,-15106,-15362,-15618,-15874,-16130,-16386,-16642,-16898,-17154,-17410,-17666,-17922,-18178,-18434,-18690,-18946,-19202,-19458,-19714,-19970,-20226,"
    PYDB(1) = "zha1,han1,qiu2,xi1,yan3,wu2,you4,fen2,an4,can3,qing2,li2,du2,qu1,yi1,xia2,you3,chu4,dai4,lin2,she4,ao2,qi2,mi2,zhu3,Jun1,ji3,mi2,hui1,me5,lie4,huan2,bin4,jiu1,quan2,xiu1,zi1,ji4,tiao2,ran2,mao2,kun1,biao1,yong1,tao1,tie4,yan4,xiang3,chi1,wang3,xiao1,liang3,yan3,ba2,mei4,du2,bin4,kuan1,qia4,lou2,bi4,ke1,ge2,hou2,di3,gu3,ku1,tou2,jie4,bei4,gou1,rou2,ju1,jian1,man2,qiao2,da2,yang1,da2,li3,zun1,shan4,gui4,yong1,min3,man2,xue3,biao4,le4,yao2,guan1,ta3,qi2,ao2,"
    PYDB(2) = "sao1,bian1,huang2,fu4,qiu1,e4,die2,fen4,zi1,shi1,diao1,nian2,ni2,gu4,chang1,kun1,fei1,zou1,ling2,qing1,ji4,huan4,sha1,gun3,tiao2,shi2,jian1,lian2,li2,geng3,xun2,xiang3,jiao1,ji4,er2,wei3,jie2,gui1,tai2,hou4,fu4,su1,lu2,nian2,ping2,ba4,fang2,you2,xin1,bei4,liu2,ao4,mou2,zan4,wu4,luan2,qiong2,chou2,qu2,luo4,ju1,Jun4,sun3,zhui1,tuo2,yuan2,mian3,wo4,chuo4,yu3,yin2,zi1,tiao2,bao1,ju3,chen4,mai2,xian4,ai3,yin2,sha4,fei1,pei4,ji4,ting2,wen2,li4,yu2,liang4,qing3,zi1,zhi4,su4,gong1,"
    PYDB(3) = "zi1,gu1,shang1,jue2,hu2,pi2,mo4,xiu1,mo4,diao1,zhi4,xie4,zuan1,lie4,chan2,lin4,zhu2,cu4,fan2,pu3,jue3,chu2,qi1,pan2,nie4,rou2,pian2,cuo1,duo2,ju3,zhong3,chuai4,die2,jian4,zhi2,bo2,dian3,zhi4,chi2,huai2,chuo1,ji4,liang2,jiao1,ji1,xian1,xian3,bi4,qiao1,kui3,tai2,bo3,jia1,tuo2,li4,shan1,fu1,zhi2,qiang1,fu1,jian3,ta1,bo1,bie2,cu4,xue2,qiong2,dun3,cuo2,shi3,xun1,li3,ju4,xi1,jiao4,bu2,lao2,tang2,hai3,xu3,ti2,hu2,pei1,kun1,lei4,tu2,cheng2,shai1,yan4,zhi3,ming3,xian1,tuo2,zuo4,"
    PYDB(4) = "gu1,yi3,zhou4,gan1,ding3,chi3,jiang1,zhe3,nan3,zan3,zi1,lie4,ju1,jiu1,qu1,fu1,dao4,yao2,qi3,qi2,zhi2,jiao3,yi4,he2,pian1,jian3,fei3,zhu4,xi1,ling2,yi4,ji4,gen4,jiang4,qiu3,rou2,xu3,ci2,zan1,hou2,shen1,zong4,lin2,can4,zi1,xi1,tiao4,li4,ba1,mi3,xian1,xi1,tang1,jie2,suo1,qiang3,di1,bi4,sha1,qiu2,jia1,niao3,qin1,meng2,chong1,cao2,shou3,meng3,wei3,shao1,xi1,ze2,zhu2,lu2,ge3,fang3,ban3,zhong1,bi3,yi3,shan1,chuan2,nv4,nie4,xi4,chong1,yu2,yu2,zhou4,lai4,bo3,deng1,zan1,dian4,"
    PYDB(5) = "gui3,duan4,lu4,dou1,mie4,su4,chi2,bi4,li4,fei3,gou1,hou2,huang2,kui4,zhen1,xiao1,yuan1,kong1,dan1,bi4,tuo4,qian2,ruo4,zhu4,qie4,ze2,qing4,xiao3,shao1,pa2,gang4,shi4,Jun1,zheng1,quan2,yan2,xian3,bi4,kou4,chi1,bian1,jia1,tiao2,si4,li4,gou3,ze2,sheng1,da2,po3,qiong2,hu4,zi3,zhao4,jian3,ji1,du3,ji2,yu2,zhu2,shi4,xia4,qing4,ying1,fou3,qu2,du4,li2,mie4,lian2,chan2,meng3,huo4,shan4,pan2,hui4,peng2,mao2,shuai4,zhang1,zhong1,xiang4,xi1,tang2,piao1,cao2,huang2,shi4,pang2,tang2,chi1,xi1,yuan2,ma2,"
    PYDB(6) = "mang3,man3,ao2,qin2,mou2,bian1,you2,lou2,you2,yu2,sou1,fu4,ke1,kui2,fu2,nan3,rong2,chun1,meng3,lang2,wan1,quan2,tiao2,pi2,yi4,guo1,guo3,fei1,yu4,xi1,qi2,qing1,qiang1,fu2,chu2,li2,wu2,shao1,zhe1,shen4,mou2,yang2,jiao1,qi2,kuo4,ting2,qu1,si1,zhi4,nao2,jia2,qiong2,you4,cheng1,ling2,qiu1,zha4,ran2,you2,li4,ke1,gu1,han1,chi1,yin3,dou3,gong1,jie4,hao2,xian3,rui4,pi2,fu2,meng2,ge4,hui1,chai4,ji3,qiu2,qian2,hu3,pin2,ru2,hao4,sang3,man1,nie4,zhuan1,e4,han4,ke1,ying3,he2,jie2,"
    PYDB(7) = "hang2,qi2,han1,tan2,ao2,kui4,guo1,ning2,ling2,dan1,ding1,die2,mo4,nou4,jiang3,lou2,ou3,tang1,lao4,huo1,si4,chao4,zi3,lei3,jin1,cun1,Jun1,xu1,ya3,pan4,ru2,qiang3,zhe3,chi3,lan2,bian3,lv3,bao3,bei4,da1,duo1,ju1,bi4,ti4,chu3,biao3,jian3,lian3,cheng2,lian2,ken4,ge1,jia2,dang1,pan4,mei4,jin1,ren4,na4,cha3,yi1,yu3,ju4,xun1,yu2,ke1,dou4,tiao3,yao3,bian3,zhun1,qiong2,xi1,song3,yi4,qu2,dian1,pi3,dian4,yi4,lai4,ban1,chou1,yin3,long2,zhai4,ying3,luo3,biao1,huang2,ji2,ban1,mo4,chi4,"
    PYDB(8) = "sao4,jia3,lou4,chai4,hou2,yi4,la4,dan1,yu1,yu3,wei3,gu4,fei4,zhu2,sha1,xian2,cuo2,wu4,lao2,zhi4,yi2,ya3,jia1,xuan2,zhu4,pao4,zha4,da5,ke1,gan1,you2,li4,shan4,li4,jie1,ding1,bing4,guan4,lu4,hu4,yu4,jiu4,jiao1,liao2,liu4,zhe4,ying1,jian1,yao4,wu4,mei2,ci2,e4,hu2,chun2,bei1,an1,miao2,wu3,ti2,xian2,yu4,hu2,li2,bo2,luan2,xiu1,gua1,zhi4,er2,si1,chi1,qu2,lu2,dong1,gu1,zhen4,bao3,yuan1,jiu1,yong3,hu4,die2,po2,xi1,hao4,jiao3,gui1,rang2,fu4,nian2,se4,ji4,zhen3,"
    PYDB(9) = "ren3,ke1,lang2,fu1,ji1,lv3,shu2,mo4,zi3,bi3,zhi4,cuo2,shen3,zhong1,biao1,cha3,yi4,zhuo2,huo4,deng4,qiang1,cuan1,pu3,lan2,dui4,lu3,pu2,jue2,tan2,di2,xuan4,zu2,yong1,luo2,man4,tang2,biao1,bin1,jia1,yi4,liu2,na2,juan1,ge2,mo4,mei2,fei4,qiang1,lou4,ai1,huan2,sou1,cha1,e4,si1,kai3,qie4,zi1,tan2,juan3,pei2,huo1,gu4,kun1,ke4,de2,ben1,nuo4,qiang1,a1,ju1,qin3,lang2,jian3,kai1,liu3,lue4,cuo4,e2,gao4,li3,zeng4,keng1,te4,lai2,lao2,ru2,an3,tang1,chong4,se4,zheng1,yao2,sha1,"
    PYDB(10) = "ha1,quan2,hua2,diu1,ding4,zhu1,kai3,yin1,diao4,cheng1,ye2,nao2,jia2,cheng2,you3,er3,lao3,kao4,duo2,pi2,ni2,bi4,ta1,xuan4,shi4,shuo4,dian4,tan3,mu4,yue4,bo2,bu1,po3,ke1,gu3,zheng1,yu4,ba3,huo3,tou3,kang4,fang1,qian2,ban3,ju4,tai4,bu4,nv3,chai1,men2,shan1,chuan4,tu3,liao3,zhao1,po1,yi3,ga2,jin1,juan1,guan4,he2,zeng1,ji1,li2,lan3,pi2,yan3,li4,gu3,gang1,fu2,tuan3,wan3,she1,zhen3,fan4,tian2,quan3,bi4,ding1,gu3,lin2,kan4,cheng1,piao3,ming2,ke1,mao4,kui2,sou3,rui4,pi4,sui1,"
    PYDB(11) = "ni4,ya2,suo1,di4,jian3,lai4,mou2,chi1,zi4,sui1,yi2,yuan1,sheng3,dan1,miao3,dun3,kou1,mian3,xu1,fu3,fu2,zhi3,kan1,bo2,meng2,ca3,jiang1,deng4,dun1,qu2,qing4,sang3,gun3,zhe2,bian3,xuan4,di4,jie2,zhou2,chen3,ding4,bei4,dui4,qi4,wo4,ge4,nao2,dong4,zhai4,qiao1,xia2,mang2,xing2,fu2,tuo2,la2,di3,tong2,zha3,long2,li4,ai4,fa3,feng1,bian1,zhuo2,ya4,dun4,che1,hua1,dang4,gan1,ji1,miao3,xue2,ta4,yu4,yu4,gang4,men4,mao4,dui4,qi4,te4,min3,qian1,que4,zi4,yang4,nin2,nv4,hui4,jia2,dui4,"
    PYDB(12) = "tan3,te4,rang2,xi3,zhuo2,xi4,chan2,qi2,tiao1,zhen1,ci2,zhi1,mi2,zuo4,fu2,hu4,qu1,zhi3,xian1,si4,shi4,fei1,hu4,jiong1,hu4,li4,xi1,xu4,tao1,si4,cuan4,jue2,xian3,sui4,fan2,yu4,yi4,yun4,shang1,man4,liu1,tui4,bian1,xuan1,bao1,duan4,wei1,yu4,hu2,yan4,chao1,men4,han2,wu4,yang2,ye4,tai2,xuan4,zhu4,hu1,shi2,qiang4,dun4,wei3,yang2,yi3,liu2,ni3,jing1,zhan1,mao2,pei4,yu2,lan2,ji1,fei3,hu2,gu1,gou4,shu1,biao1,biao1,sou1,ju4,sa4,biao1,xi1,xin1,sha4,yi1,xi1,yu2,lin4,lian2,"
    PYDB(13) = "shan1,sao4,meng2,gu3,chuai4,zhi4,teng2,bin4,lv3,ge2,ying4,cheng2,shu4,e4,wa4,mian3,nan3,cou4,jian4,ding4,zong1,yu2,fei2,yan1,jing1,niao4,wan3,pao1,cuo3,luo2,tun2,mi3,zhen4,pian2,hai3,sa4,kuai4,yan1,dong4,guang1,jing4,zhi1,qu2,zhen1,gua1,zuo4,zhou4,shen4,jia3,lu2,ka3,dong4,long2,qian3,yao2,na4,zhun1,gong1,tai4,ruan3,jing3,huang1,rong2,wo4,yue4,guo2,yuan2,you3,die2,du2,jiao3,chi4,fan3,yun1,ke4,yin1,ya4,dong1,chuan1,xian1,dao1,pie1,qu2,pu3,lu5,chang3,shu1,san1,jian4,cui4,mu2,mao4,bo4,ge2,"
    PYDB(14) = "bai1,suo1,qie4,kao4,pian1,jian1,ju4,ji1,gu4,wu3,gu3,mao2,pin4,jiang4,jian4,qu4,jin4,gou4,yu2,di2,xi2,ji4,chan1,fu4,dan3,ji1,qiu2,lai4,zhen4,jin4,gai1,zi1,zhi4,yi2,kuang4,shi4,ben1,nang3,xi1,yao4,xun1,tun1,ming2,ai4,kui2,xuan1,gui3,han2,bu1,hui1,yan4,chao2,ye4,sheng4,qi2,ni4,chang3,yu4,mao3,zan3,he2,gui4,yun2,xin1,ze4,gao3,tan2,hao4,gan4,la2,ga1,po1,pi4,zeng4,beng4,bu4,ling2,ou1,zang1,jian3,gai4,deng3,kan1,ji2,ji3,jia2,qiang1,jian1,wei4,lin2,lu4,cou4,zi1,chuo4,"
    PYDB(15) = "wang3,nian3,zhe2,lu4,quan2,zhi4,shi4,yao2,li4,hu1,zhen3,yi4,zhi3,lu2,ke1,gu1,e4,ren4,yi4,bin4,ji2,dan1,piao3,lian4,yun3,tian3,shang1,cu2,mo4,ao2,you2,cha2,bo4,lin3,yan2,lei2,yuan2,ju2,xi1,zun1,lu3,qin2,qiao2,jue2,tuo2,qing2,yue4,gan3,hu2,zhu1,tang2,chu1,qi4,qiang2,jin3,xie4,zhu1,rong2,bin1,shuo4,gao3,cui1,gao1,xie4,sun3,ta4,fei3,zhen1,ying2,mei2,xuan4,ju3,cha2,lv2,chen4,chui2,duan4,qiu1,ju3,pin3,ji2,lan3,lian4,zha1,nan2,zhen1,cou4,ju1,di4,jian4,guo3,liang2,chui2,luo2,"
    PYDB(16) = "zhao4,qian4,du2,fen2,chu3,ling2,suo1,zi3,jue2,fu2,gu4,fan4,xu3,an1,juan4,luan2,jie2,gui4,heng2,hua4,jiu4,gua1,ting3,qi1,guang1,zhen1,zhi4,rao2,ya1,lao3,kao3,cheng1,tuo2,li4,di3,gou3,ling2,zhi1,tuo4,zhi3,you4,xiao1,xia2,lu2,ping2,jiu4,long2,zhe4,zhi4,nai4,zhu4,pa2,fang1,xiao1,cong1,cheng2,chu3,jian3,rui4,yao3,miao3,pi2,li4,ma4,cha1,qi3,shao2,wu4,tao1,yun4,wei3,wen4,zan4,bi4,lu4,qu2,can4,pu2,zhang1,xuan2,cong1,cui3,ying1,huang2,jin3,tang2,ai4,nao3,xia2,yuan4,yu2,mao4,ju1,chen1,"
    PYDB(17) = "wan3,cong2,yan3,kun1,hu3,qi2,ying1,qi2,lian3,hui1,xi3,luo4,yao2,heng2,ya2,xu1,gong3,er3,jia1,min2,po4,dai4,dian4,long2,ke1,jue2,min2,bin1,wei3,ji1,ding1,yong1,zai1,chuan1,ji1,yao1,zuan3,huan2,qiao1,qian3,jiang1,zeng1,liao2,xie2,sao1,miao4,lei2,man4,piao1,bin1,jian1,yi4,li2,gao3,ru4,zhen3,jin4,min2,zhui4,gou1,bian4,si1,hui4,miao3,ti2,xiang1,ke4,zi1,wan3,quan3,liu3,shou4,duo3,gun3,shang4,fei1,qi3,ling2,ti2,xiao1,geng3,jiang4,hang2,ku4,dai4,chu4,fu2,zhou4,fu2,xie4,gan4,shu1,pi1,yun2,"
    PYDB(18) = "kuang4,wan2,ge1,zhou4,yu1,jiao3,xiang1,ji4,chan3,cong1,biao1,shan4,liu2,ao4,wu4,zhi4,can1,zhui1,ke4,qi2,li2,pian2,hua2,xiao1,dai4,nu2,yi4,zou1,fu4,si4,zang3,bao1,jue2,jie2,zi1,nu2,fu2,ga2,ga3,shuang1,mo2,niao3,bi4,shan4,xi1,zhang1,lei2,chang2,piao2,qiang2,yan1,li2,chi1,pin2,ai4,pi4,mo2,gou4,wu4,ting2,yuan2,ao3,nu3,chan2,bi4,chang1,jie2,biao3,jing4,e1,wei3,di4,suo1,xian2,wa1,ping1,li3,cha4,pin1,jiao1,luan2,shu1,rao2,ya4,qie4,shan1,zhou2,da2,si4,yu2,niu1,gui1,zi3,jin4,"
    PYDB(19) = "bi3,yu4,wu3,yan2,fei1,shuo4,chu1,yu4,bi4,fu2,mi3,nu3,jing4,chan4,ju4,xi3,chan2,e1,ji1,zhi3,kao1,zhi4,tuan4,hui4,xun2,la1,sui4,miao3,xie4,ju4,lin2,xian1,liu2,ta1,gou4,ao2,xia2,qiu2,huang2,chuan2,lu4,huan4,wei1,kui2,qun1,ti4,xiao1,qiu2,li3,bu1,pang2,hou4,dai4,jing4,jia1,er3,yi3,ze2,jiong3,wu3,ya4,zou3,jian3,jian3,huan2,qian1,liao2,wu4,qian1,qian1,ning2,chen2,you4,mi4,dang4,gui3,bao3,ba4,hao4,fen4,yue4,ying2,xie4,han4,zhuo2,hao2,bi4,pu2,ru2,lian2,chan2,dan4,li3,sui1,"
    PYDB(20) = "lai4,chan2,tong2,shao4,shan1,si1,shu4,gan3,xuan2,lu4,yi1,zhu1,lian4,huan4,luo4,hu1,cao2,lan3,xiao1,ying2,huang2,ming2,pang1,tang2,fu3,xiu4,bi4,hun4,ta1,ru4,li4,pu3,ying2,mang3,she4,ke4,qin2,yan4,mei2,wo4,xuan4,jian1,pen2,xu4,huang2,sou1,qiu1,mian3,yan1,xie4,shuan4,lu4,guan4,shen3,cong2,fei2,gan4,mian3,pi4,zhuo1,du2,song1,xi1,qi2,zhu3,huan4,mei3,xi1,bang1,cen2,juan1,zhuo2,wei2,lai2,wu2,su4,ru4,xun2,hu3,liu2,jiang4,xun2,tao2,hui4,xu4,ji4,zhu1,hui2,yin1,zhen1,jia1,lie4,wei3,huan2,"
    PYDB(21) = "jing1,min3,hong2,tuo2,pan4,xuan4,luo4,mao3,ling2,duo4,si4,yang1,lu2,long2,shu4,gan1,le4,wei2,hang4,wen4,bian4,gu3,mi4,dun4,mian3,mu4,yuan2,feng1,cha4,si4,qi4,san1,qiang1,pan2,zhuang4,kan4,que4,tian2,he2,que4,qu4,e4,hun1,wen2,xi4,chang1,yu4,lang2,jiu1,kun3,lv2,ta4,kang1,min3,hong2,wei2,yan2,shuan1,hui1,tian3,meng3,lin3,chu4,chong1,qiao2,jing3,yong1,qie4,su4,bi4,qiao3,zhui4,leng4,e4,kui4,yun4,cui4,hu1,chou2,wang3,chang3,fei3,xing4,qie4,quan1,ti4,yi4,kun3,kui1,qian1,song3,bei4,yun4,ke4,"
    PYDB(22) = "xun2,kai3,ce4,yan1,tong4,yi2,yi4,chao1,fu2,ni2,zuo4,yang4,da2,peng1,chu4,hu4,niu3,bian4,song1,chuang4,chang4,kai4,wu3,chong1,ou4,zhi4,wu3,chan4,cun3,dao1,shu4,ying1,lin3,xie4,chan2,jin3,ao2,geng1,bi4,yu3,an1,tuo3,xiang2,xiu1,pao2,gui3,wu3,pi3,nang2,zhuan4,san3,jin3,xiu1,mo2,sou1,zha5,hun2,yu2,bo1,xiang3,yi2,chi4,yu4,ren4,xi4,tun2,tang2,shi4,dong1,yin2,sun1,huo3,chuan3,huan1,xun1,xie4,liao2,jue2,jing4,zhang1,nao2,mei2,wei4,wei3,cha2,hu2,mi2,cu4,she1,ni2,luo2,guo3,yi1,suan1,"
    PYDB(23) = "yin2,xian3,yu2,li4,juan4,bi4,sun1,shou4,kuai4,rong2,fei4,pao2,xia2,yun3,niu3,ma3,guang3,an4,qiu2,fan3,san1,qu2,jiao3,zheng1,yao2,huang2,chang2,xi3,lai2,hou4,yang2,xun4,cu2,pang2,chi4,dian1,yi2,bin1,deng4,lin2,zhang4,ji2,song1,sheng4,mei2,zi1,lou3,cuo2,yu2,wei2,zai3,wai3,yao3,rong2,jue2,kong1,guo1,xiao2,gu4,yan1,song1,lai2,lao2,zheng1,xun2,qiao2,dong4,yi4,min2,mao3,gou3,dai4,xiu4,jia3,dong1,ke3,hu4,ba1,lan2,cen2,ao4,xian4,ya2,qu1,qi2,qian1,qi3,ji2,fan1,fu2,zhang4,man4,wo4,wei2,"
    PYDB(24) = "guo2,ze2,dao4,tang3,pei4,zhi4,wei2,huan2,yu3,qing1,yu3,you4,ling2,hu2,lun2,nan1,jian3,wei2,nang1,huo4,cha1,ru2,pi1,sai1,yi1,jue2,jin4,hao1,deng1,ceng1,lu1,qin2,o1,jiao4,chuai4,pu1,liao2,jue1,peng1,mi4,di1,sou3,beng1,ying1,qi1,piao4,cao2,lei5,pei4,chi1,tong1,hei1,suo1,ai4,ai4,dia3,hao2,en4,a2,ge2,suo1,chen1,he1,nie4,ke1,du1,su4,ao2,qin2,hui4,wo1,ku4,lou5,jie1,chi4,yin1,sou1,jiu1,kui4,yong2,jie1,kui2,li2,nan2,da1,die2,chuo4,shua1,li4,lang1,ding4,bo5,dan4,yo1,"
    PYDB(25) = "sha4,cui4,hu1,tao2,zhou1,zhuan4,lin2,miao1,nuo4,ze2,feng3,ji1,zuo4,xi1,zao4,suo3,zha1,en2,geng3,lao4,chi1,mai4,mou1,gen2,nong2,zha4,mi1,mie1,ji4,duo3,kuai4,pai4,yi1,xiu1,yue3,guang1,ci1,bi4,xiao1,yi2,lie3,da1,hui1,shen3,ji1,kuang1,si1,you1,nao2,duo1,ning2,dong1,ling4,gua1,ga1,ka1,za1,yin3,qin4,guo1,bei5,bi3,e5,li4,tai3,yi4,mu2,fu1,yao1,a1,zha4,le4,dao1,kou4,ji1,chi4,bu3,shi4,dai4,tui1,yi4,nang3,zuan4,huo1,zhuo2,xing3,pi3,huan4,gan3,cuan1,zun3,lu1,xie2,zhe2,"
    PYDB(26) = "han4,zhi2,ying1,luo4,sang3,nuo4,zhan3,shuo4,jian1,chuai1,en4,shu1,yuan4,kui2,bing4,xuan1,an3,yu2,qin4,ya4,zha1,die2,guan4,qian2,lie4,pou2,ju1,bai3,guo2,ji3,na4,ai2,ye2,tian4,Jun4,lv3,yi4,za1,jiao3,jie2,niu4,pin1,fu3,chen1,tuan2,men2,ti2,gan1,ga4,liao4,you2,pao2,zang4,xi1,yi4,da1,lian2,kuang3,yi4,nong4,mi2,nie4,fan2,heng2,qu2,huo4,li2,gao3,xian3,xun1,ru2,tai2,hao1,bi4,sou3,weng4,yi4,wei1,hong1,xie4,hong2,qi2,fan1,meng2,ji2,zui4,rui2,jue2,xun4,hui4,liao3,xu5,kou4,qu2,"
    PYDB(27) = "lin4,cu4,lian3,xi3,dou1,meng2,su4,yu4,ying2,lang4,shuo4,jian1,bang4,li2,ji2,hao1,weng3,bei4,en1,mo4,ru4,shi1,zhen1,jia1,xuan1,pai4,lou2,ting2,pa1,bao3,e4,xi3,kui4,qi4,kai3,chan3,wei1,xiang1,shen4,feng1,qia1,han4,gu1,ying2,wan3,jian1,dang4,zu1,yan1,cui4,dan4,tu2,fu2,bi4,huan2,yu2,tie1,chang1,shu1,ba2,qi1,nai4,jin3,song1,xi1,qi2,jing1,chun2,ying1,lang4,guan3,shen1,di2,you2,sui1,piao3,xian1,tu2,li4,you2,mei2,e2,you3,wo1,shi4,bi2,kan3,zhou4,hong2,sun1,mai3,jin4,gen4,qian2,"
    PYDB(28) = "ying2,luo4,jiang1,chong1,jiao1,qi2,ming2,xun2,hui4,quan2,xing4,ren3,fu2,qiao2,ting2,zhu1,hui2,tong2,ju3,zi3,bi4,rao2,yi2,qian4,tiao2,min2,qiong2,ying2,mao2,yin4,niao3,ling2,fu2,chi2,qing3,ran3,ju1,mu4,ba2,long2,pie3,gan1,mo4,yi3,kou1,zhu4,bian4,shan1,qi2,qian4,wu4,qin2,cong1,chang2,xian4,rui4,zhi3,pi2,ju4,e4,li4,ji4,fei4,yun2,yuan2,fu2,xiang1,qi3,xiong1,wan2,ji1,qian1,du4,nai3,jiao1,cao3,yi4,pi2,xin1,chi2,liang2,yong1,man4,yuan2,ge2,hou4,leng2,yin1,die2,ku1,dai4,sao4,tu4,peng2,"
    PYDB(29) = "nian4,pi2,yi4,an3,zhi2,yuan4,lie4,xun1,guo1,shi2,cheng2,yin2,gai1,nao3,shang3,shan1,kai3,dong4,die2,ya1,ao4,mu3,ni2,tuo2,di3,che4,lu2,dian4,long3,gan1,ban3,qi2,li4,yi2,pi3,kuang4,zhen4,ge1,wu1,xu1,he4,yong1,ji1,shu2,fa2,e4,ben4,qiu2,ben3,bian4,si1,chang4,dang4,shan1,jian4,jue2,xie4,sou3,xie2,xu4,meng3,ge3,he2,shao4,qu2,mai4,huan4,chu2,feng1,ling2,zou1,shan4,po2,zhang1,yin2,yan1,juan4,yan3,tan2,pi2,fu2,xi1,gao4,ying3,li4,yun4,xun2,qie4,kuai4,zhu1,zhi4,jia2,tai2,di3,"
    PYDB(30) = "ye4,bei4,pi1,bing3,fang1,wu1,mang2,kuang4,qiong2,han2,xi2,wei3,huang2,wei1,pi2,chui2,zou1,nie4,zhi4,gai1,xing2,bei1,zuo4,yan2,ban3,jing3,qian1,wu4,zuo3,jin3,dan1,chen4,zhan1,yan4,jue2,qiao2,zen4,jian3,zhe2,mi4,shi4,su4,dang3,mo2,pian3,zi1,di4,an1,xuan1,yu4,e4,ye4,xue4,jian4,chen2,sui4,chan3,shen3,yu2,wei3,zhuo2,zou1,ei1,kuang2,gao4,qiao4,xu3,hun4,zheng4,quan2,gou4,shen1,hui1,jie2,gua4,lei3,kuang1,yi2,qu1,zhao4,di3,he1,gu3,ne4,ju4,ou1,shan4,hong4,jie2,yan2,ming2,zhong3,ping2,song1,"
    PYDB(31) = "xian3,lie4,hu4,liang3,lei2,luo3,ying2,bing3,pou2,luan2,xie4,mao4,gun3,bo2,yan3,wen2,si4,su4,fu2,fu2,hong1,pu2,bao1,kui2,chan3,guo2,hong2,xun4,xi1,di2,cuan1,yue4,zu3,qian1,she2,tun3,tong2,dan1,xuan1,tong2,jiu4,jiao1,jian4,jing3,xi1,chi4,nuo2,bin1,tang3,lv3,zong3,wei1,ji4,xie2,yan3,fen4,ju4,kong1,guan1,ti4,bi3,wo1,luo3,shu1,zhuo1,pai2,ruo4,qian4,feng4,si4,yong3,ping1,yu3,li3,qiu2,li4,yan3,chou2,mou2,nong2,jiao3,chai2,tiao1,yi4,zhu1,kan3,kua3,you4,er4,ji2,ga1,ni4,tuo2,tong2,"
    PYDB(32) = "gou1,yi4,you1,ka3,ning4,zhu4,kang4,cang1,chang1,wu3,wa3,ya2,pi3,yu3,ren4,mu4,yi4,sa1,le4,zhang3,ding1,dan1,wang3,tong2,yi4,huo1,qiao1,jue2,piao1,kuai3,wan1,yan3,ji1,la4,kai3,gui4,ku1,jing3,wen3,yi4,ce4,you3,gua4,ze2,bian3,kui4,gui3,po3,qu1,yan4,ye4,si1,jue2,yan3,cuo4,she4,ze4,gu3,se4,bo2,mi3,qi2,ji1,nie4,nai4,ji2,dian3,tao2,gao1,yu4,kui2,yin4,xin4,di1,zhi1,yao2,yao1,tuo1,bi3,pie3,yu2,shu4,e4,nao1,ge2,cheng2,gen4,pi1,sa4,nian4,gai4,wu1,ji1,chu4,"
    PYDB(33) = "zuo4,zuo4,zuo4,zuo4,zha4,zuo3,zuo3,zuo2,zun1,zun1,zui4,zui4,zui4,zui3,zuan3,zuan4,zu3,zu3,zu3,zu3,zu2,zu2,zu2,zu1,zou4,zou4,zou3,zou1,zong4,zong3,zong1,zong1,zong1,zong1,zong1,zi4,zi4,zi4,zi3,zi3,zi3,zai3,zi3,zi1,zi1,zi1,zi1,zi1,zi1,zi1,zhuo2,zhuo2,zhe5,zhuo2,zhuo2,zhuo2,zhuo2,zhuo1,zhuo2,zhuo1,zhuo1,zhun3,zhun1,zhui4,zhui4,zhui4,zhui1,zhui1,zhui1,zhuang4,zhuang4,zhuang4,zhuang1,zhuang1,zhuang1,zhuang1,zhuan4,zuan4,zhuan4,zhuan3,zhuan1,zhuan1,zhuai4,zhao3,zhua1,zhu4,zhu4,zhu4,zhu4,,,,,,"
    PYDB(34) = "zhu4,zhu4,zhu4,zhu4,zhu4,zhu4,zhe5,zhu3,zhu3,zhu3,zhu3,zhu3,zhu2,zhu2,zhu2,zhu1,zhu1,zhu1,zhu1,zhu1,zhu1,zhu1,zhou4,zhou4,zhou4,zhou4,zhou4,zhou3,zhou3,zhou2,zhou1,zhou1,zhou1,zhou1,zhou1,zhou1,zhong4,zhong4,zhong4,zhong3,zhong3,zhong1,zhong1,zhong1,zhong1,zhong1,zhong1,zhi4,zhi4,zhi4,zhi4,zhi4,zhi4,zhi4,zhi4,zhi4,zhi4,zhi4,zhi4,zhi4,zhi4,zhi4,zhi4,zhi4,zhi4,zhi3,zhi3,zhi1,zhi3,zhi3,zhi3,zhi3,zhi2,zhi2,zhi2,zhi2,zhi2,zhi2,zhi2,zhi1,zhi1,zhi1,zhi1,zhi1,zhi1,zhi1,zi1,zhi1,zhi1,zhi1,zheng4,zheng4,zheng4,zhen1,"
    PYDB(35) = "zheng4,zheng4,zheng3,zheng3,zheng1,zheng1,zheng1,zheng1,zheng1,zheng4,zheng1,zhen4,zhen4,zhen4,zhen4,zhen3,zhen3,zhen3,zhen1,zhen1,zhen1,zhen1,zhen1,zhen1,zhen1,zhen1,zhen1,zhe4,zhe4,zhe4,zhe3,zhe3,zhe2,zhe2,zhe2,zhe2,zhe1,zhao4,zhao4,zhao4,zhao4,zhao4,zhao4,zhao3,zhao3,zhao1,zhao1,zhang4,zhang4,zhang4,zhang4,zhang4,zhang4,zhang4,zhang4,zhang3,zhang3,zhang1,zhang1,zhang1,zhang1,zhang1,zhan4,zhan4,zhan4,zhan4,zhan4,zhan4,zhan4,zhan3,zhan3,nian3,zhan3,zhan3,zhan1,zhan1,zhan1,zhan1,zhan1,zhai4,zhai4,zhai3,zhai2,zhai1,zhai1,zha4,zha4,zha4,za3,zha4,shan1,zha3,zha2,zha2,"
    PYDB(36) = "zha2,zha2,zha1,zha1,zha1,zeng4,ceng2,zeng1,zeng1,zen3,zei2,ze2,ze2,ze2,ze2,zao4,zao4,zao4,zao4,zao4,zao4,zao3,zao3,zao3,zao3,zao3,zao2,zao1,zao1,zang4,zang1,zang1,zan4,zan4,zan3,zan2,zai4,zai4,zai3,zai3,zai1,zai1,zai1,za2,za2,za1,yun4,yun4,yun1,yun4,yun4,yun4,yun3,yun3,yun2,yun2,yun2,yun2,yue4,yue4,yue4,yue4,yue4,yao4,yue4,yue4,yue1,yue1,yuan4,yuan4,yuan4,yuan4,yuan3,yuan2,yuan2,yuan2,yuan2,yuan2,yuan2,yuan2,yuan2,yuan2,yuan2,yuan2,yuan2,yuan1,yuan1,yuan1,yu4,yu4,yu4,yu4,yu4,yu4,"
    PYDB(37) = "yu4,yu4,yu4,yu4,yu4,yu4,yu4,yu4,yu4,xu1,yu4,yu4,yu4,yu4,yu3,yu3,yu3,yu3,yu3,yu3,yu3,yu2,yu3,yu2,yu2,yu2,yu2,yu2,yu2,yu2,yu2,yu2,yu2,yu2,yu2,yu2,yu2,yu1,yu1,you4,you4,you4,you4,you4,you4,you3,you3,you3,you2,you2,you2,you2,you2,you2,you2,you1,you1,you1,you1,yong4,yong3,yong3,yong3,yong3,yong3,yong3,yong3,yong3,yong1,yong1,yong1,yong1,yong4,yong1,yo1,ying4,ying4,ying3,ying3,ying2,ying2,ying2,ying2,ying2,ying2,ying2,ying2,ying1,ying1,ying1,ying1,ying1,ying1,yin4,"
    PYDB(38) = "yin3,yin3,yin3,yin3,yin2,yin2,yin2,yin2,yin1,yin1,yin1,yin1,yin1,yin1,yin1,yi4,yi4,yi4,yi4,yi4,yi4,yi4,yi4,yi4,yi4,yi4,yi4,yi4,yi4,yi4,yi4,yi4,yi4,yi4,yi4,yi4,yi4,yi4,yi4,yi4,yi4,yi4,yi3,yi3,yi3,yi3,yi3,yi3,yi3,yi2,yi2,yi2,yi2,yi2,yi2,yi2,yi2,yi2,yi2,yi2,yi1,yi1,yi1,yi1,yi1,yi1,yi1,yi1,ye4,ye4,ye4,ye4,ye4,ye4,ye4,ye4,ye3,ye3,ye3,ye2,ye1,ye1,ye1,yao4,yao4,yao4,yao3,yao3,yao2,yao2,yao2,yao2,yao2,yao2,"
    PYDB(39) = "yao2,yao1,yao1,yao1,yang4,yang4,yang3,yang3,yang3,yang3,yang2,yang2,yang2,yang2,yang2,yang2,yang2,yang1,yang1,yang1,yang1,yan4,yan4,yan4,yan4,yan4,yan4,yan4,yan4,yan4,yan4,yan4,yan4,yan3,yan3,yan3,yan3,yan3,yan2,yan2,yan2,yan2,yan2,yan2,yan2,yan2,yan2,yan2,yan2,yan1,yan1,yan1,yan1,yan1,ya4,ya4,ya3,ya3,ya2,ya2,ya2,ya2,ya2,ya2,ya1,ya5,ya1,ya1,ya1,ya1,xun4,xun4,xun4,xun4,xun4,xun4,xun2,xun4,xun2,xun2,xun2,xun2,xun1,xun1,xue4,xue3,xue2,xue2,xue1,xue1,xuan4,xuan4,xuan3,xuan3,"
    PYDB(40) = "xuan2,xuan2,xuan2,xuan1,xuan1,xuan1,xu4,xu4,xu4,xu4,xu4,chu4,xu4,xu4,xu4,xu4,xu4,xu3,xu2,xu1,xu1,xu1,xu1,xu1,xu1,xiu4,xiu4,xiu4,xiu4,xiu4,xiu3,xiu1,xiu1,xiu1,xiong2,xiong2,xiong1,xiong1,xiong1,xiong1,xiong1,xing4,xing4,xing4,xing4,xing3,hang2,xing2,xing2,xing2,xing2,xing4,xing1,xing1,xing1,xing1,xin4,xin4,xin1,xin1,xin1,xin1,xin1,xin1,xin1,xin1,xie4,xie4,xie4,xie4,xie4,xie4,xie4,xie4,xie3,xie2,xie2,xie2,xie2,xie2,jia1,xie2,xie2,xie1,xie1,xie1,xie1,xiao4,xiao4,xiao4,xiao1,xiao4,xiao4,xiao3,"
    PYDB(41) = "xiao3,xiao2,xiao1,xiao1,xiao1,xiao1,xiao1,xue1,xiao1,xiao1,xiao1,xiang4,xiang4,xiang4,xiang4,xiang4,xiang4,xiang3,xiang3,xiang3,xiang2,xiang2,xiang2,xiang1,xiang1,xiang1,xiang1,xiang1,xiang1,xiang1,xiang4,xian4,xian4,xian4,xian4,xian4,xian4,xian4,xian4,xian4,xian4,xian3,xian3,xian2,xian2,xian2,xian2,xian2,xian2,xian2,xian2,xian1,xian1,xian1,xian1,xian1,xian1,xia4,xia4,sha4,xia4,xia2,xia2,xia2,xia2,xia2,xia2,xia2,xia1,xia1,xi4,xi4,xi4,xi4,xi3,xi3,xi3,xi2,xi2,xi2,xi2,xi2,xi1,xi1,xi1,xi1,xi1,xi1,xi1,xi1,xi1,xi1,xi1,xi1,"
    PYDB(42) = "xi1,xi1,xi1,xi1,xi1,xi1,xi1,xi1,xi1,xi1,xi1,wu4,wu4,wu4,wu4,wu4,wu4,wu4,wu4,wu4,wu3,wu3,wu3,wu3,wu3,wu3,wu3,wu2,wu2,wu2,wu2,wu2,wu2,wu1,wu1,wu1,wu1,wu1,wu1,wu1,wo4,wo4,wo4,wo4,wo3,wo1,wo1,wo1,wo1,weng4,weng1,weng1,wen4,wen3,wen3,wen3,wen2,wen2,wen2,wen2,wen1,wen1,wei4,wei4,wei4,wei4,wei4,wei4,wei4,wei4,wei4,wei4,wei4,wei4,wei4,wei3,wei3,wei3,wei3,wei3,wei3,wei3,wei2,wei2,wei2,wei2,wei2,wei2,wei2,wei2,wei2,wei1,wei1,wei1,"
    PYDB(43) = "wei1,wang4,wang4,wang4,wang4,wang3,wang3,wang3,wang2,wang2,wang1,wan4,wan4,wan3,wan3,wan3,wan3,wan3,wan3,wan3,wan2,wan2,wan2,wan2,wan2,wan1,wan1,wan1,wai4,wai1,wa4,wa3,wa2,wa1,wa1,wa5,wa1,tuo4,tuo4,tuo3,tuo3,tuo2,tuo2,tuo2,tuo2,tuo1,tuo1,tuo1,tun2,tun2,tun1,tui4,tui4,tui4,tui3,tui2,tui1,tuan2,tuan1,tu4,tu3,tu3,tu2,tu2,tu2,tu2,tu2,tu1,tu1,tu1,tou4,tou2,tou2,tou1,tong4,tong3,tong3,tong3,tong3,tong2,tong2,tong2,tong2,tong2,tong2,tong2,tong1,ting3,ting3,ting2,ting2,ting2,ting2,ting1,"
    PYDB(44) = "ting1,ting1,ting1,tie1,tie3,tie1,tiao4,tiao4,tiao2,tiao2,tiao1,tian3,tian3,tian2,tian2,tian2,tian2,tian1,tian1,ti4,ti4,ti4,ti4,ti4,ti4,ti3,ti2,ti2,ti2,ti2,ti1,ti1,ti1,ti1,teng2,teng2,teng2,teng2,te4,tao4,tao3,tao2,tao2,tao2,tao2,tao2,tao1,tao1,tao1,tao1,tang4,tang4,tang3,tang3,tang3,tang2,tang2,tang2,tang2,tang2,tang2,tang2,tang1,tan4,tan4,tan4,tan4,tan3,tan3,tan3,tan2,tan2,tan2,tan2,tan2,tan2,tan1,tan1,tan1,tan1,tan1,tai4,tai4,tai4,tai4,tai4,tai2,tai2,tai2,tai1,ta4,ta4,ta4,ta3,"
    PYDB(45) = "ta3,ta1,ta1,ta1,ta1,suo3,suo3,suo3,suo3,suo1,suo1,suo1,suo1,sun3,sun3,sun1,sui4,sui4,sui2,sui4,sui4,sui4,sui3,sui2,sui2,sui2,sui1,suan4,suan4,suan1,su4,su4,xiu3,su4,su4,su4,su4,su4,su4,su2,su1,su1,sou4,sou3,sou1,sou1,song4,song4,song4,song4,song4,song3,song3,song1,si4,si4,si4,si4,si4,si4,si4,si4,si3,si1,si1,si1,si1,si1,si1,si1,shuo4,shuo4,shuo4,shuo1,shun4,shun4,shun4,shun3,shui4,shui4,shui3,shui2,shuang3,shuang1,shuang1,shuan1,shuan1,shuai4,shuai3,shuai1,shuai1,shua3,shua1,shu4,"
    PYDB(46) = "shu4,shu4,shu4,shu4,shu4,shu4,shu4,shu4,shu4,shu4,shu3,shu3,shu3,shu3,shu3,shu3,shu3,shu3,shu2,shu2,shu2,shu1,shu1,shu1,shu1,shu1,shu1,shu1,shu1,shu1,shu1,shu1,shou4,shou4,shou4,shou4,shou4,shou4,shou3,shou3,shou3,shou1,shi4,shi4,shi4,shi4,shi4,shi4,shi4,shi4,shi4,shi4,shi4,shi4,shi4,shi4,shi4,shi4,shi4,shi4,shi4,shi4,shi4,shi4,shi4,shi4,shi3,shi3,shi3,shi3,shi3,shi3,shi2,shi2,shi2,shi2,shi2,shi2,shi2,shi2,shi2,shi1,shi1,shi1,shi1,shi1,shi1,shi1,shi1,sheng4,sheng4,sheng4,sheng4,sheng3,"
    PYDB(47) = "sheng2,sheng1,sheng1,sheng1,sheng1,sheng1,shen4,shen4,shen4,shen4,shen3,shen3,shen3,shen2,shen1,shen1,shen1,shen1,shen1,shen1,shen1,shen1,she4,she4,she4,she4,she4,she4,she4,she3,she2,she2,she1,she1,shao4,shao4,shao4,shao3,shao2,shao2,shao2,shao1,shao1,shao1,shao1,shang5,shang4,shang4,shang3,shang3,shang1,shang1,shang1,shan4,shan4,shan4,shan4,shan4,shan4,shan4,shan3,shan3,shan1,shan1,shan1,shan1,shan1,shan1,shan1,shai4,shai1,sha4,sha2,sha3,sha1,sha1,cha4,sha1,sha1,sha1,seng1,sen1,se4,se4,se4,sao3,sao3,sao1,sao1,sang4,sang3,sang1,san4,san3,"
    PYDB(48) = "san1,san1,sai4,sai1,sai1,sai1,sa4,sa3,sa1,ruo4,ruo4,run4,run4,rui4,rui4,rui3,ruan3,ruan3,ru4,ru4,ru3,ru3,ru3,ru2,ru2,ru2,ru2,ru2,rou4,rou2,rou2,rong3,rong2,rong2,rong2,rong2,rong2,rong2,rong2,rong2,rong2,ri4,reng2,reng1,ren4,ren4,ren4,ren4,ren4,ren4,ren3,ren2,ren2,ren2,re4,re3,rao4,rao3,rao2,rang4,rang3,rang3,rang3,rang2,ran3,ran3,ran2,ran2,qun2,qun2,que4,que4,que4,que4,que4,que2,gui4,que1,quan4,quan4,quan3,quan2,quan2,quan2,quan2,quan2,quan2,quan2,quan1,qu4,qu4,qu3,qu3,qu3,"
    PYDB(49) = "qu2,qu1,qu1,qu1,qu3,qu1,qu1,qu1,qiu2,qiu2,qiu2,qiu2,qiu2,qiu1,qiu1,qiu1,qiong2,qiong2,qing4,qing3,qing3,qing2,qing2,qing2,qing2,qing1,qing1,qing1,qing1,qing1,qing1,qin4,qin3,qin2,qin2,qin2,qin2,qin2,qin2,qin1,qin1,qin1,qie4,qie4,qie3,qie2,qie1,qiao4,qiao4,qiao4,qiao4,qiao4,qiao4,qiao3,qiao2,qiao2,qiao2,qiao2,qiao1,qiao1,qiao1,qiao1,qiang3,qiang2,qiang2,qiang2,qiang1,qiang1,qiang4,qiang1,qian4,qian4,qian4,qian4,qian3,qian3,qian3,qian2,qian2,qian2,qian2,qian2,qian2,qian1,qian1,qian1,qian1,qian1,qian1,qian1,qian1,qian1,qia4,qia4,"
    PYDB(50) = "qia1,qi4,qi4,qi4,qi4,qi4,qi4,qi4,qi4,qi4,qi3,qi3,qi3,qi3,qi3,qi2,qi2,qi2,qi2,qi2,qi2,qi2,qi2,qi2,qi2,qi2,qi2,qi1,qi1,qi1,qi1,qi1,qi1,qi1,qi1,qi1,qi1,bao4,pu4,pu3,pu3,pu3,pu3,pu3,pu3,pu2,pu2,pu2,pu2,pu2,pu4,pu1,pou1,po4,po4,po4,po4,po2,po1,po1,po1,ping2,ping2,ping2,ping2,ping2,ping2,ping2,ping2,ping1,pin4,pin3,pin2,pin2,pin1,pie1,pie3,piao4,piao2,piao1,piao1,pian4,pian4,pian1,pian1,pi4,pi4,pi4,pi3,pi3,pi2,pi2,pi2,pi2,"
    PYDB(51) = "pi2,pi2,pi1,pi1,pi1,pi1,pi1,pi1,peng4,peng3,peng2,peng2,peng2,peng2,peng2,peng2,peng2,peng2,peng2,peng1,peng1,peng1,pen2,pen1,pei4,pei4,pei4,pei2,pei2,pei2,pei2,pei1,pei1,pao4,pao3,pao2,pao4,pao2,pao2,pao1,pang4,pang3,pang2,pang2,pang1,pan4,pan4,pan4,pan4,pan2,pan2,pan1,pan1,pai4,pai4,pai2,pai2,pai2,pai1,pa2,pa4,pa4,pa2,pa1,pa1,ou1,ou3,ou3,ou3,ou1,ou1,ou1,o4,nuo4,nuo4,nuo4,nuo2,nue4,nue4,nuan3,nv3,nu4,nu3,nu2,nong4,nong2,nong2,nong2,niu3,niu3,niu3,niu2,ning4,ning3,"
    PYDB(52) = "ning2,ning2,ning2,ning2,nin2,nie4,nie4,nie4,nie4,nie4,nie4,nie1,niao4,niao3,niang4,niang2,nian4,nian3,nian3,nian3,nian2,nian1,nian1,ni4,ni4,ni4,ni4,ni3,ni3,ni2,ni2,ni2,ni2,ni1,neng2,nen4,nei4,nei3,ne5,nao4,nao4,nao3,nao3,nao2,nang2,nan2,nan2,nan2,nai4,nai4,nai3,nai3,nai3,na4,na4,na4,na4,na4,na3,na2,mu4,mu4,mu4,mu4,mu4,mu4,mu4,mu4,mu4,mu4,mu3,mu3,mu3,mu3,mu3,mou3,mou2,mou2,mo4,mo4,mo4,mo4,mo4,mo4,mo4,mo4,mo3,mo2,mo2,mo2,mo2,mo2,mo2,mo2,"
    PYDB(53) = "mo1,miu4,ming4,ming2,ming2,ming2,ming2,ming2,min3,min3,min3,min3,min3,min2,mie4,mie4,miao4,miao4,miao3,miao3,miao3,miao2,miao2,miao2,mian4,mian3,mian3,mian3,mian3,mian3,mian2,mian2,mian2,mi4,mi4,mi4,mi4,mi4,mi4,mi3,mi2,mi2,mi2,mi2,mi2,mi2,mi1,meng4,meng4,meng3,meng3,meng2,meng2,meng2,meng2,men5,men4,men2,mei4,mei4,mei4,mei4,mei3,mei3,mei3,mei2,mei2,mei2,mei2,mei2,mei2,mei2,mei2,mei2,me5,mao4,mao4,mao4,mao4,mao4,mao3,mao3,mao2,mao2,mao2,mao2,mao1,mang3,mang2,mang2,mang2,mang2,mang2,man4,"
    PYDB(54) = "man4,man4,man4,man4,man3,man2,man2,man2,mai4,mai4,mai4,mai4,mai3,mai2,ma5,ma5,ma4,ma3,ma3,ma3,ma3,ma2,ma1,luo4,luo4,luo4,luo4,luo3,luo2,luo2,luo2,luo2,luo2,luo2,luo2,lun4,lun2,lun2,lun2,lun2,lun2,lun2,lue4,lue3,luan4,luan3,luan2,luan2,luan2,luan2,lv4,lv4,lv4,lv4,lv4,lv4,lv3,lv3,lv3,lv3,lv3,lv3,lv3,lv2,lu4,lu4,lu4,lu4,lu4,lu4,lu4,lu4,lu4,lu4,lu4,lu3,lu3,lu3,lu3,lu2,lu2,lu2,lu2,lu2,lou4,lou4,lou3,lou3,lou2,lou2,long3,long3,long3,long2,"
    PYDB(55) = "long2,long2,long2,long2,long2,liu4,liu3,liu2,liu2,liu2,liu2,liu2,liu2,liu2,liu2,liu1,ling4,ling4,ling3,ling3,ling2,ling2,ling2,ling2,ling2,ling2,ling2,ling2,ling2,ling2,lin1,lin4,lin4,lin3,lin2,lin2,lin2,lin2,lin2,lin2,lin2,lin2,lie4,lie4,lie4,lie4,lie4,liao4,liao4,liao4,liao4,le5,liao2,liao2,liao2,liao2,liao2,liao2,liao2,liao2,liang4,liang4,liang4,liang4,liang4,liang3,liang2,liang2,liang2,liang2,liang2,lian4,lian4,lian4,lian4,lian3,lian3,lian2,lian2,lian2,lian2,lian2,lian2,lian2,lian2,liang3,li3,li2,li4,li4,li4,li4,li4,li4,"
    PYDB(56) = "li4,li4,li4,li4,li4,li4,li4,li4,li4,li4,li4,li4,li4,li3,li3,li3,li3,li3,li2,li2,li2,li2,li2,li2,li2,li2,leng3,leng2,leng2,lei4,lei4,lei4,lei4,lei3,lei3,lei4,lei3,lei3,lei2,lei2,le4,le4,lao4,lao4,lao4,lao3,lao3,lao3,lao2,lao2,lao1,lang4,lang3,lang2,lang2,lang2,lang2,lang2,lan4,lan4,lan3,lan3,lan3,lan3,lan2,lan2,lan2,lan2,lan2,lan2,lan2,lan2,lan2,lai4,lai2,lai2,la1,la4,la4,la4,la3,la1,la1,kuo4,kuo4,kuo4,kuo4,kun4,kun3,kun1,kun1,kui4,kui4,kui4,"
    PYDB(57) = "gui1,kui2,kui2,kui2,kui1,kui1,kui1,kui1,kuang4,kuang4,kuang4,kuang4,kuang4,kuang2,kuang1,kuang1,kuan3,kuan1,kuai4,kuai4,kuai4,kuai4,kua4,kua4,kua4,kua3,kua1,ku4,ku4,ku4,ku3,ku1,ku1,ku1,kou4,kou4,kou3,kou1,kong4,kong3,kong3,kong1,keng1,keng1,ken3,ken3,ken3,ken3,ke4,ke4,ke4,ke4,ke3,ke3,hai1,ke2,ke1,ke1,ke1,ke1,ke1,ke1,ke3,kao4,kao3,kao3,kao3,kang4,kang4,kang4,kang2,kang1,kang1,kang1,kan4,kan3,kan3,kan1,kan1,kan1,kai3,kai3,kai3,kai1,kai1,ge1,ka3,ka1,ka1,Jun4,Jun4,xun4,Jun4,Jun4,"
    PYDB(58) = "Jun4,Jun1,Jun1,Jun1,Jun1,Jun1,jue2,jue2,jue2,jiao4,jue2,jue4,jue2,jue2,jue2,jue1,juan4,juan4,juan4,juan4,juan1,juan1,juan1,ju4,ju4,ju4,ju4,ju4,ju4,ju4,ju4,ju4,ju4,ju4,ju4,ju4,ju3,ju3,ju3,ju3,ju2,ju2,ju1,ju1,ju1,ju1,ju1,ju1,jiu4,jiu4,jiu4,jiu4,jiu4,jiu4,jiu4,jiu4,jiu3,jiu3,jiu3,jiu3,jiu3,jiu3,jiu1,jiu1,jiu1,jiong3,jiong3,jing4,jing4,jing4,jing4,jing4,jing4,jing4,jing4,jing4,jing4,jing3,jing3,jing3,jing3,jing1,jing1,jing1,jing1,jing1,jing1,jing1,jing1,jing1,jing1,jing1,jin4,jin4,"
    PYDB(59) = "jin4,jin4,jin4,jin4,jin4,jin4,jin4,jin3,jin3,jin3,jin3,jin1,jin1,jin1,jin1,jin1,jin1,jin1,jie4,jie4,jie4,jie4,jie4,jie4,jie4,jie4,jie4,jie3,jie3,jie2,jie2,jie2,jie2,jie2,jie2,ju2,jie1,jie2,jie2,jie1,jie1,jie1,jie1,jie1,jie1,jiao4,jiao4,jiao4,jiao4,jiao4,jiao1,jiao3,jiao3,jiao3,jiao3,jiao3,jiao3,jiao3,yao2,jiao3,jiao3,jiao3,jiao2,jiao1,jiao1,jiao1,jiao1,jiao1,jiao1,jiao1,jiao1,jiao1,jiao1,jiang4,jiang4,jiang4,jiang3,jiang3,jiang3,jiang3,jiang1,jiang1,jiang1,jiang1,jiang1,jiang1,jian4,jian4,jian4,jian4,jian4,jian4,jian4,jian4,"
    PYDB(60) = "jian4,jian4,jian4,jian4,jian4,jian4,jian4,kan3,jian4,jian3,jian3,jian3,jian3,jian3,jian3,jian3,jian3,jian3,jian3,jian3,jian1,jian1,jian1,jian1,jian1,jian1,jian1,jian1,jian1,jian1,jian1,jian1,jia4,jia4,jia4,jia4,jia4,jia3,jia3,jia3,jia3,jia2,jia2,jia1,jia1,jia1,jia2,jia1,jia1,ji4,ji4,ji4,ji4,ji4,ji4,ji4,ji4,ji4,ji4,ji4,ji4,ji4,ji4,ji4,ji4,ji4,ji4,ji4,ji3,ji3,ji3,ji3,ji2,ji2,ji2,ji2,ji2,ji2,ji2,ji2,ji2,ji2,ji2,ji2,ji2,ji1,ji4,ji1,ji1,ji1,ji1,ji4,ji1,ji1,"
    PYDB(61) = "ji1,ji1,ji1,ji1,ji1,ji1,ji1,ji1,huo4,huo4,huo4,huo4,huo4,huo4,huo3,huo3,huo2,huo1,hun2,hun2,hun2,hun1,hun1,hun1,hui4,hui4,hui4,hui4,hui4,hui4,hui4,hui4,hui4,hui4,hui4,hui4,hui3,hui3,hui2,hui2,hui1,hui1,hui1,hui1,hui1,huang3,huang3,huang3,huang3,huang2,huang2,huang2,huang2,huang2,huang2,huang2,huang2,huang1,huang1,huan4,huan4,huan4,huan4,huan4,huan4,huan4,huan4,huan4,huan3,hai2,huan2,huan2,huan1,huai4,huai2,huai2,huai2,huai2,hua4,hua4,hua2,hua4,hua2,hua2,hua2,hua2,hua1,hu4,hu4,hu4,hu4,hu3,hu3,hu2,"
    PYDB(62) = "hu2,hu2,hu2,hu2,hu2,hu2,hu2,hu2,hu1,hu1,hu1,hou4,hou4,hou4,hou3,hou2,hou2,hou2,hong2,hong2,hong2,hong2,hong2,hong2,hong1,hong3,hong1,heng2,heng2,heng2,heng1,heng1,hen4,hen3,hen3,hen2,hei1,hei1,he4,he4,he4,he4,he2,he2,he2,mo4,he2,he2,he2,he2,he2,he2,he2,he2,he1,he1,hao4,hao4,hao4,hao3,hao3,hao2,hao2,hao2,hao2,hang2,hang2,ben4,han4,han4,han4,han4,han4,han4,han4,han4,han4,han3,han3,han2,han2,han2,han2,han2,han2,han1,han1,hai4,hai4,hai4,hai4,hai3,hai2,hai2,"
    PYDB(63) = "ha3,guo4,guo3,guo3,guo2,guo1,guo1,gun4,gun3,gun3,gui4,gui4,gui4,gui4,gui4,gui3,gui3,gui3,gui3,gui1,gui1,gui1,gui1,gui1,gui1,gui1,guang4,guang3,guang1,guan4,guan4,guan4,guan4,guan3,guan3,guan1,guan4,guan1,guan1,guan1,guai4,guai3,guai1,gua4,gua4,gua3,gua3,gua1,gua1,gu4,gu4,gu4,gu4,gu3,gu3,gu3,gu3,gu3,gu3,gu1,gu1,gu1,gu1,gu1,gu1,gu1,gu1,gou4,gou4,gou4,gou4,gou3,gou3,gou1,gou1,gou1,gong4,gong4,gong3,gong3,gong3,gong1,gong1,gong1,gong1,gong4,gong1,gong1,gong1,gong1,gong1,geng3,geng3,geng3,"
    PYDB(64) = "geng1,geng1,geng4,geng1,gen1,gen1,gei3,ge4,ge4,ge4,ge2,ge2,ha2,ge2,ge3,ge2,ge1,ge1,ge1,ge1,ge1,ge1,ge1,ge1,gao4,gao3,gao3,gao3,gao1,gao1,gao1,gao1,gao1,gao1,gang4,gang3,gang3,gang1,gang1,gang1,gang1,gang1,gang1,gan4,gan3,gan3,gan3,gan3,gan1,gan1,gan1,gan3,gan1,gan4,gai4,gai4,gai4,gai4,gai3,gai1,ga1,ga2,fu4,fu4,fu4,fu4,fu4,fu4,fu4,fu4,fu4,fu4,fu4,fu4,fu4,fu4,fu4,fu4,fu4,fu3,fu3,fu3,pu2,fu3,fu3,fu3,fu3,fu3,fu3,fu2,fu2,fu2,fu2,fu2,"
    PYDB(65) = "fu2,fu2,fu2,fu2,fu2,fu2,fu2,fu2,fu2,fu1,fu1,fu1,fu1,fou3,fo2,feng4,feng4,feng3,feng2,feng2,feng2,feng1,feng1,feng1,feng1,feng1,feng1,feng1,feng1,feng1,fen4,fen4,fen4,fen4,fen4,fen3,fen2,fen2,fen2,fen1,fen4,fen1,fen1,fen1,fen1,fei4,fei4,fei4,fei4,fei4,fei3,fei3,fei2,fei1,fei1,fei1,fei1,fang4,fang3,fang3,fang3,fang2,fang2,fang2,fang2,fang1,fang1,fang1,fan4,fan4,fan4,fan4,fan4,fan3,fan3,fan2,fan2,fan2,fan2,fan2,fan2,fan1,fan1,fan1,fan1,fa4,fa3,fa2,fa2,fa2,fa2,fa2,fa1,er4,"
    PYDB(66) = "er4,er3,er3,er3,er3,er2,er2,en1,e4,e4,e4,e4,e4,e4,e2,e2,e2,e2,e2,e2,e2,duo4,duo4,duo4,duo4,duo4,duo3,duo3,duo3,duo2,duo1,duo1,duo1,dun4,dun4,dun4,dun4,dun4,dun1,dun1,dun1,dun1,dui4,dui4,dui4,dui1,duan4,duan4,duan4,duan4,duan3,duan1,du4,du4,du4,du4,du4,du4,du3,du3,du3,du2,du2,du2,du2,du1,dou1,dou4,dou4,dou4,dou3,dou4,dou3,dou1,dong4,dong4,dong4,dong4,dong4,dong4,dong3,dong3,dong1,dong1,diu1,ding4,ding4,ding4,ding3,ding3,ding4,ding1,ding1,ding1,"
    PYDB(67) = "die2,die2,die2,die2,die2,die1,die1,diao4,diao4,diao4,diao4,diao1,diao1,diao1,diao1,diao1,dian4,dian4,dian4,dian4,dian4,dian4,dian4,dian4,dian4,dian4,dian3,dian3,dian3,dian1,dian1,dian1,di4,di4,di4,di4,di4,di4,di4,di3,di3,di2,zhai2,di2,di2,di2,di2,di2,di1,di1,di1,deng4,deng4,deng4,deng3,deng1,deng1,deng1,de5,de2,de2,dao4,dao4,dao4,dao4,dao4,dao3,dao3,dao3,dao3,dao3,dao3,dao1,dang4,dang4,dang3,dang3,dang1,dan4,tan2,dan4,dan4,dan4,dan4,dan4,dan4,dan3,dan3,dan1,dan1,dan1,dan1,dan1,dai4,"
    PYDB(68) = "dai3,dai4,dai4,dai4,dai4,dai4,dai4,dai4,dai3,dai3,dai1,da4,da3,da2,da2,da2,da1,cuo4,cuo4,cuo4,cuo1,cuo1,cuo1,cun4,cun2,cun1,cui4,cui4,cui4,cui4,cui4,cui1,cui1,cui1,cuan4,cuan4,cuan1,cu4,cu4,cu4,cu1,cou4,cong2,cong2,cong1,cong1,cong1,cong1,ci4,ci4,ci4,ci3,ci2,ci2,ci2,ci2,ci2,ci2,ci2,ci1,chao1,chuo1,chun3,chun2,chun2,chun2,chun2,chun1,chun1,chui2,chui2,chui2,chui1,chui1,chuang4,chuang3,chuang2,zhuang4,chuang1,chuang1,chuan4,chuan3,chuan2,chuan2,chuan2,chuan1,chuan1,chuai1,chu4,chu4,chu4,chu4,chu3,chu3,"
    PYDB(69) = "chu3,chu2,chu2,chu2,chu2,chu2,chu2,chu2,chu1,chu1,chou4,chou3,chou3,chou2,chou2,chou2,chou2,chou2,chou2,chou2,chou2,chou1,chong3,chong2,chong2,chong1,chong1,chi4,chi4,chi4,chi4,chi3,chi3,chi3,chi3,chi2,chi2,chi2,chi2,shi5,chi2,chi1,chi1,cheng4,cheng3,cheng3,cheng2,cheng2,cheng2,cheng2,cheng2,cheng2,cheng2,cheng2,cheng2,cheng2,cheng1,cheng1,chen4,chen4,chen2,chen2,chen2,chen2,chen2,chen2,chen2,chen1,che4,che4,che4,che4,che3,che1,chao3,chao3,chao2,chao2,chao2,chao2,chao1,chao1,chao1,chang4,chang4,chang4,chang3,chang3,chang2,chang2,chang2,chang2,chang2,chang3,"
    PYDB(70) = "chang1,chang1,chan4,chan3,chan3,chan3,chan2,chan2,chan2,chan2,chan1,chan1,chai2,chai2,chai1,cha4,cha4,cha4,cha2,cha2,cha2,cha2,cha2,cha2,cha1,cha1,ceng4,ceng2,ce4,ce4,ce4,ce4,ce4,cao3,cao2,cao2,cao1,cao1,cang2,cang1,cang1,cang1,cang1,can4,can3,can2,can2,can2,can1,can1,cai4,cai4,cai3,cai3,cai3,cai3,cai2,cai2,cai2,cai2,cai1,ca1,bu4,bu4,bu4,bu4,bu4,bu2,bu4,bu3,bu3,bu3,bu3,bo2,bo2,bo2,bo2,bo2,bo2,bo2,bo2,bo2,bo2,bo2,bo2,bo2,bo1,bo1,bo1,bo1,bo1,bo1,bing4,bing4,"
    PYDB(71) = "bing3,bing3,bing3,bing3,bing3,bing1,bing1,bin4,bin1,bin1,bin1,bin1,bin1,bie3,bie2,bie1,bie1,biao3,biao1,biao1,biao1,bian4,bian4,bian4,bian4,bian4,bian4,bian4,bian3,bian3,bian1,bian1,bian1,bi4,bi4,bi4,bi4,pi4,bi4,bi4,bi4,bi4,bi4,bi4,bi4,bi4,bi4,bi4,bi4,bi4,bi4,bi3,bi3,bi3,bi3,bi2,bi1,beng4,beng4,beng4,beng2,beng1,beng1,ben4,ben3,ben3,ben1,bei4,bei4,bei4,bei4,bei4,bei4,bei4,bei4,bei4,bei4,bei3,bei1,bei1,bei1,bei1,bao4,bao4,bao4,bao4,bao4,bao4,bao3,bao3,bao3,bao3,bao2,bao2,"
    PYDB(72) = "bao1,bao1,bao1,bao1,bao1,bang4,bang4,bang4,bang4,pang2,bang4,bang3,bang3,bang3,bang1,bang1,bang1,ban4,ban4,ban4,ban4,ban4,ban4,ban4,ban3,ban3,ban1,ban1,ban1,ban1,ban1,ban1,bai4,bai4,bai4,bai3,bai3,bai3,bai3,bai2,ba4,ba4,ba4,ba4,pa2,ba3,ba3,ba2,ba2,ba1,ba1,ba1,ba1,ba5,ba1,ba1,ba1,ba1,ao4,ao4,ao4,ao4,ao3,ao2,ao2,ao2,ao1,ang4,ang2,ang1,an4,an4,an4,an4,an4,an3,an1,an1,an1,ai4,ai4,ai4,ai4,ai3,ai3,ai2,ai2,ai1,ai1,ai1,ai1,ai1,a1,a1,"

    Db = Split(PYDB(0), ",")

    ReDim PY_Index(UBound(Db))
    For i = 1 To UBound(Db)
        PY_Index(i) = Db(i - 1)
    Next i
    For i = 1 To 72
        Db = Split(PYDB(i), ",")
        For j = 1 To UBound(Db)
            PY_DB(i, j) = Db(j - 1)
        Next j
    Next i
End Sub
Function PinYin(TXT As Variant, Optional Delimiter As String = "") As String
    Dim N As Integer
    Dim ASCID As Long
    Dim Y As Byte
    Dim M_Txt As String
    Dim M_PY As String
    Dim MI_PY As String

    On Error Resume Next
    Call DealVal_1

    If TXT = "" Then
        PinYin = ""
        Exit Function
    End If

    For i = 1 To Len(Trim(TXT))
        M_Txt = Mid(Trim(TXT), i, 1)
        If M_Txt = "" Then
            MI_PY = ""
        Else
            ASCID = Asc(M_Txt)
            For N = 1 To UBound(PY_Index)
                If PY_Index(N) < ASCID Then
                    Exit For
                End If
            Next N
            PYDB_Index = PY_Index(N - 1) - ASCID
            If PYDB_Index < 0 Or PYDB_Index > 93 Then
                M_PY = M_Txt
                Y = 1
            Else
                M_PY = PY_DB(N - 1, PYDB_Index + 1)
            End If
        End If
        MI_PY = M_PY
        PinYin = PinYin & IIf(M_PY = M_Txt, MI_PY, IIf(Y = 1, Delimiter & MI_PY & Delimiter, IIf(i = Len(Trim(TXT)), MI_PY, MI_PY & Delimiter)))
        PinYin = UCase(Left(PinYin, 1)) & Mid(PinYin, 2, Len(PinYin) - 2)
        Y = IIf(Y = 1, IIf(M_PY = M_Txt, 1, 0), 0)
    Next i

End Function
赞(5) 打赏
转载请标明出处:高海鹏老师的博客 » Excel中汉字转拼音的实现
分享到: 更多 (0)

留言 15

Protected by WP Anti Spam
  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址
  1. #0

    这个方法确实完美解决(姓名转拼音,无音标、无空格、首字母大写、所有汉字都没问题),但由于网页转码问题共有4行标红出错,共7处需要修改。【正常打字输入的话,错误的地方在网页上依然显示不出来的,就像前面3位前辈留言一样看不懂,我在每个字符中间都加个空格,意思表达到了就行】。1、原代码中【& l t ;】表示“小于号”,在excel的AB代码编辑栏中将这4个字符改为1个字符【网页上显示不出来,键盘正常打出小于号即可】。原代码中共2行2个地方需要修改。2、原代码中【& g t ;】表示“大于号”,在excel的AB代码编辑栏中将这4个字符改为1个字符【网页上显示不出来,键盘正常打出大于号即可】。原代码中共1行1个地方需要修改。3、原代码中【& a m p ;】表示“与号”,在excel的AB代码编辑栏中将这5个字符改为1个字符【&】。原代码中共2行4个地方需要修改。。。好了,说的够明白了吧。造福搜到这里的网友!

    八百3年前 (2021-08-06)回复
    • 高海鹏3年前 (2021-08-06)回复
  2. #0

    大家复制粘贴代码后,会有 4 行报红,按下面方式替换就可以了
    “`
    1. 将 `<` 替换为 “ 一共有 1 处
    3.将 `&` 替换为 `&` 一共有 5 处
    (其实就是符号被转义的问题)
    “`

    SIlentims4年前 (2021-05-26)回复
  3. #0

    解决出错问题了:
    1、& 替换为 &
    2、< 替换为

    Hi4年前 (2021-04-08)回复
  4. #0

    <
    修改为

    &amp;
    修改为&
    造福老帖子

    4年前 (2021-02-19)回复
  5. #0

    代码好用。非常感谢博主。

    飞刀9年前 (2016-05-07)回复
  6. #0

    有三个字符被转换成,分别是“”和“&”,所以有三行代码报错
    另外转码中jun的拼音,j变成了大写,与其他的不一致
    其他的都非常好

    stophere11年前 (2014-07-30)回复
    • 我还真没注意,感谢提醒!

      高海鹏11年前 (2014-07-30)回复
    • 这个问题修复了吗?

      moon6年前 (2019-04-02)回复
  7. #0

    代码几经删除空格换行,减除VB里红线,最终测试无用,结果显示没有内容,好过修改前显示乱码

    xa11年前 (2014-06-04)回复
    • 我在2003下测试可用,没有问题啊。

      高海鹏11年前 (2014-06-05)回复
  8. #0

    你的代码无效,是否放到网页上被屏蔽了某些字符?

    lhs11年前 (2014-05-09)回复
    • 最后一段代码可以使用,我正在用。

      高海鹏11年前 (2014-05-09)回复
    • 复制的时候尽量不要用Chrome浏览器,EXCEL2003下测试可用。

      高海鹏11年前 (2014-05-09)回复
      • 可用
        就是转不出来的字就不显示了。能不能保留

        po10年前 (2014-11-21)回复

觉得文章有用就打赏一下文章作者

支付宝扫一扫打赏

微信扫一扫打赏