thaicosmic.com

หนัง

วันพุธที่ 30 มกราคม พ.ศ. 2562

ตัดเครื่องหมาย - ออกจากเลขประชาชน

Excel                =SUBSTITUTE(E2,"-","")
Access              Replace([65CKD].pid,"-","") AS cid;
mySQL             REPLACE(pid,'-','') as cid

วันพุธที่ 23 มกราคม พ.ศ. 2562

AUTO DATACORRECT FROM JHCIS 201601231033

HOSPCODE|TABLENAME|DATA_CORRECT|D_UPDATE
03301|PRENATAL|{"GRAVIDA":"4","HOSPCODE":"03301","PID":"11645","EDITOR_CID":"3330300309025"}|20181113102032
03301|diagnosis_opd|{"SEQ":"190635","EDITOR_CID":"3330300309025","PID":"11645","DATE_SERV":"20181112"}|20181113102329
03301|PRENATAL|{"GRAVIDA":"4","HOSPCODE":"03301","PID":"11645","EDITOR_CID":"3330300309025"}|20181214092512
03301|PRENATAL|{"GRAVIDA":"4","HOSPCODE":"03301","PID":"11645","EDITOR_CID":"3330300309025"}|20181214094901
03301|PRENATAL|{"GRAVIDA":"4","HOSPCODE":"03301","PID":"11645","EDITOR_CID":"3330300309025"}|20181214095124
03301|PRENATAL|{"GRAVIDA":"4","HOSPCODE":"03301","PID":"11645","EDITOR_CID":"3330300309025"}|20181214095222
03301|PRENATAL|{"GRAVIDA":"4","HOSPCODE":"03301","PID":"11645","EDITOR_CID":"1339900306533"}|20181226150313
03301|PRENATAL|{"GRAVIDA":"4","HOSPCODE":"03301","PID":"11645","EDITOR_CID":"3330300309025"}|20181228111400
03301|PRENATAL|{"GRAVIDA":"4","HOSPCODE":"03301","PID":"11645","EDITOR_CID":"3330300309025"}|20181228111523
03301|PRENATAL|{"GRAVIDA":"4","HOSPCODE":"03301","PID":"11645","EDITOR_CID":"3330300309025"}|20181228111624
03301|PRENATAL|{"GRAVIDA":"4","HOSPCODE":"03301","PID":"11645","EDITOR_CID":"3330300309025"}|20181228111745