Greetings all,
I'm trying to work out when using a format specifier I get spaces in the resulting string. Eg. Looking at the outputted string you can see that there are spaces after T5LAT, F4LAT etc. as I result from trying to keep the code aligned Does anyone have any insights in how to prevent this ? Regards Gavin --- Code Fragment --- fmtSqlP300Amp = 'UPDATE Patient SET \ O2AMP = "%s", O1AMP = "%s", OzAMP = "%s", PzAMP = "%s", P4AMP = "%s", CP4AMP = "%s", T6AMP = "%s", C4AMP = "%s", TP8AMP = "%s", T4AMP = "%s", T5AMP = "%s", P3AMP = "%s", \ CP3AMP = "%s", CPzAMP = "%s", CzAMP = "%s", FC4AMP = "%s", FT8AMP = "%s", TP7AMP = "%s", C3AMP = "%s", FCzAMP = "%s", FzAMP = "%s", F4AMP = "%s", F8AMP = "%s", \ T3AMP = "%s", FT7AMP = "%s", FC3AMP = "%s", F3AMP = "%s", FP2AMP = "%s", F7AMP = "%s", FP1AMP = "%s" \ WHERE Pat_Id = "%s;"' sqlAmpString = fmtSqlP300Amp % ( self.ERPAmpSites[O2],self.ERPAmpSites[O1],self.ERPAmpSites[Oz],self.ERPAmpSi tes[Pz],self.ERPAmpSites[P4],self.ERPAmpSites[CP4],self.ERPAmpSites[T6], \ self.ERPAmpSites[C4],self.ERPAmpSites[TP8],self.ERPAmpSites[T4],self.ERPAmpS ites[T5],self.ERPAmpSites[P3],self.ERPAmpSites[CP3], \ self.ERPAmpSites[CPz],self.ERPAmpSites[Cz],self.ERPAmpSites[FC4],self.ERPAmp Sites[FT8],self.ERPAmpSites[TP7],self.ERPAmpSites[C3], \ self.ERPAmpSites[FCz],self.ERPAmpSites[Fz],self.ERPAmpSites[F4],self.ERPAmpS ites[F8],self.ERPAmpSites[T3],self.ERPAmpSites[FT7], \ self.ERPAmpSites[FC3],self.ERPAmpSites[F3],self.ERPAmpSites[FP2],self.ERPAmp Sites[F7],self.ERPAmpSites[FP1], self.ERPPatId) print sqlAmpString --- Output --- .................................................... sqlAmpString .................................................... UPDATE Patient SET O2AMP = "2.43119", O1AMP = "2.77413", OzAMP = "2.47781", PzAMP = "2.50786", P4AMP = "4.579", CP4AMP = "3.50302", T6AMP = "9.55172", C4AMP = "1.21119", TP8AMP = "5.6498", T4AMP = "1.29149", T5AMP = "0.565705", P3AMP = "-0.957866", CP3AMP = "-0.231566", CPzAMP = "0.970299", CzAMP = "-0.214471", FC4AMP = "-0.607667", FT8AMP = "-0.226904", TP7AMP = "-1.51269", C3AMP = "-1.26248", FCzAMP = "-1.61319", FzAMP = "-2.55086", F4AMP = "-1.87688", F8AMP = "-1.11846", T3AMP = "-1.98619", FT7AMP = "-2.0613", FC3AMP = "-1.8458", F3AMP = "-2.23433", FP2AMP = "-2.01364", F7AMP = "-1.80539", FP1AMP = "-2.00328" WHERE Pat_Id = "GT0001;"
-- http://mail.python.org/mailman/listinfo/python-list