Hello Marcel, Hi everybody
Somone has an idea how to convert or delete apostrophes in patient names which comes with HL7 entries?
i.e.: PatientName is " Smith, Peter^Moon and Star's "
Conquest (1.4.17d) givs me the error:
[MASTERPACS] ***Failed MYSQLExec : INSERT INTO DICOMWorkList (PatientID,OtherPatie,PatientNam,PatientBir,PatientSex,PatientSpe,PatientBre,SexNeutere,PatientCom,AccessionN,SchedPSID,StartDate,StartTime,ReqPhysici,Modality,ScheduledA,ReqProcPri,PerfPhysic) VALUES ('91349','987654321','Smith, Peter^Moon and Star's','20080501','M','Dog','Alaskan Husky','ALTERED','','87','','20170203','','','DX','York','','Dr. Seman')
[MASTERPACS] ***Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's','20080501','M','Dog','Alaskan Husky','ALTERED','','87','','20170203','','','' at line 1
Obviously the MySQL-Server (5.6.17) doesn't like the naked apostrophe.
Do you have an idea for an import converter which detects the apostophe in the patientname and corrects it into " \' " or at least just delete it?
( " \' " is the correct character for the apostrophe in MySQL)
Or is there an approach to solve the problem on the MySQL?
Thanks in advance for any help!
Manny