Jul-30-2018, 08:47 AM
(This post was last modified: Jul-30-2018, 08:47 AM by Axel_Erfurt.)
decimal(10,0) - the comma is a problem
a short test with decimal(10.0)
a short test with decimal(10.0)
#mylist = ["columnname:string,columnname1:int,columnname2:decimal(10,0),columnname3:decimal(9,2)"] mylist = ["columnname:string,columnname1:int,columnname2:decimal(10.0),columnname3:decimal(9.2)"] for a in ",".join(mylist).split(","): name = "%s%s" % ("col.", a.partition(":")[0]) print(name)
Output:col.columnname
col.columnname1
col.columnname2
col.columnname3