I have everything just about finished in transforming .hl7 text files into 4 sql tables, but one problem I'm having is illegal characters in my insert statement. The note field in the HL7 documents sometimes contains ' and other characters that I can't insert into SQL.
I have a variable in my filter named notes, is there some java command that is out there that I can run this through to add escape characters in my filter?
Thanks,
Jeff
I have a variable in my filter named notes, is there some java command that is out there that I can run this through to add escape characters in my filter?
Thanks,
Jeff
Comment