Writing into a csv file

[Michelle Lermon]

I am trying to write some data into a csv file, but when I write the file the data skips a line. I tried putting commas at the end of the write line but that did not work.

Attached is the part of the code where I write the data.

writer.writerow(datim + [button1]+ [row['cruise']] + [row['crunum']]+ [sitecode]+ [SeriesCode]+ [deploynum]+ [DeploymentCode]+ [ctd]+ [blat] + [blon]+[deploymenteklog]+ [Deploymentcom1 + str(deploynum)]),

writer.writerow(datim + [button2]+ [row['cruise']] + [row['crunum']]+[sitecode]+[SeriesCode]+[deploynum]+[DeploymentCode]+[ctd]+[elat]+[elon]+[deploymenteklog]+[Deploymentcom2 + str(deploynum)]),

Thanks

[bvdet]

There's not much to go on, because I have no idea what the variables are assigned to. My guess is that one of the values has a trailing newline character. The newline character can be removed with str method strip().

[Haiyan]

Since you are using the csv module and the default line termination sequence is '\r\n', that's why you get a new line. You can try following way and it should work for you.

writer.writerow(yourrow, lineterminator = '\r')

[dwblas]

You can also use strip(), and avoid the possibility that some lines contain a newline and some do not.

str_out = ""
for field in [datim, button1, row['cruise'], row['crunum'], sitecode, SeriesCode, deploynum, DeploymentCode, ctd, blat, blon, deploymenteklog, Deploymentcom1,  str(deploynum)]:
    str_out += field.strip()

And then write str_out configured however you wish.