[Tutor] need to clean a string

johnf jfabiani at yolo.com
Mon Dec 15 19:18:28 CET 2008


Hi,
I have a string that I need to extract just the sql	 statement. 
The following is the string
\000\000\000\000\000\000\000\000.\000\000\000\0000\000\000\000
\000$\000\000\000\000\000(\000\000\000\000X\000\000\000\000\000,
\000\000\000\000P\000\000\000\000\000Q\000\000\000\000\000R\000
\000\000\000\000/\000\000\000�\000\000\000\000%����\000\000\000
\000'����\000\000\000\000+brttyp\000�\000\000\000\000*SELECT 
Brttyp.ctrscode, Brttyp.cdescript, Brttyp.ctrstype, Brttyp.cstatus, 
Brttyp.lreqno, Brttyp.dcreate FROM  brttyp Brttyp WHERE  Brttyp.ctrscode = 
( ?gcKey1 )\000\000\000\000\000 AMCONNECT\000\000\000\000\000)
\000\000\000\000
\000\000\000 \000\000\000\000BR Transaction Code 
File\000

How can I get rid of all the junk?
 
I can find the '*' with str.find('*') but I can't use find '\000' to get to 
the end?
-- 
John Fabiani


More information about the Tutor mailing list