Stop spaces from appearing when printing to file

[Brad Tilley]

I'm printing some info into a txt file that will be uploaded into a
MySQL DB. I use ';' as field separaters. How can I stop spaces from
appearing on both sides of the ';'

When I do this:

print >> x,';',object,";",AN_string,";",ascii,";",sum

My file looks like this:

;12345 ; 23456 ; [1,2,3,4,5] ; 15

I need it to look like this to make the DB happy:

;12345;23456;[1,2,3,4,5];15

 

[Kent Johnson]

I'm printing some info into a txt file that will be uploaded into a
MySQL DB. I use ';' as field separaters. How can I stop spaces from
appearing on both sides of the ';'

The spaces are a feature of print. To avoid them, use string formatting
to create a single output string.

print >> x,';',object,";",AN_string,";",ascii,";",sum

Try
print >> x, ';%s;%s;%s;%s' % (object, AN_string, ascii, sum)

Kent

My file looks like this:

;12345 ; 23456 ; [1,2,3,4,5] ; 15

I need it to look like this to make the DB happy:

;12345;23456;[1,2,3,4,5];15

 

[news.west.cox.net]

The spaces are a feature of print. To avoid them, use string formatting to

create a single output string.


Try
print >> x, ';%s;%s;%s;%s' % (object, AN_string, ascii, sum)

Kent

or....

print x + ';' + object + ";" + AN_string + ";" + ascii + ";" + sum

 

[Dave Reed]

I'm printing some info into a txt file that will be uploaded into a
MySQL DB. I use ';' as field separaters. How can I stop spaces from
appearing on both sides of the ';'

When I do this:

print >> x,';',object,";",AN_string,";",ascii,";",sum

My file looks like this:

;12345 ; 23456 ; [1,2,3,4,5] ; 15

I need it to look like this to make the DB happy:

;12345;23456;[1,2,3,4,5];15

Instead of using print, open a file and use the "write" method of the
file object. See the documentation for file objects for more detail.

Dave

 

[Brad Tilley]

The spaces are a feature of print. To avoid them, use string formatting
to create a single output string.



Try
print >> x, ';%s;%s;%s;%s' % (object, AN_string, ascii, sum)

Kent

Thanks Kent, this works great.

 

[Scott David Daniels]

The spaces are a feature of print. To avoid them, use string formatting
to create a single output string.



Try
print >> x, ';%s;%s;%s;%s' % (object, AN_string, ascii, sum)

or even:
print >>x, ';'.join([str(v) for v in (object, AN_string, ascii, sum)])

-Scott David Daniels
Scott.DanielsAcm.Org

 

[Terry Hancock]

I'm printing some info into a txt file that will be uploaded into a
MySQL DB. I use ';' as field separaters. How can I stop spaces from
appearing on both sides of the ';'

When I do this:

print >> x,';',object,";",AN_string,";",ascii,";",sum

My file looks like this:

;12345 ; 23456 ; [1,2,3,4,5] ; 15

I need it to look like this to make the DB happy:

;12345;23456;[1,2,3,4,5];15

Generally speaking, you'll be better off to produce the string
you want and then print it, rather than relying on the print
command's syntax. You'll find it much more intuitive to do
either:

print x+';'+object+";"+AN_string+";"+ascii+";"+sum

or

print "%s;%s;%s;%s;%s" % (x, object, AN_string, ascii, sum)

In other words, use string operators, then print the result.

Cheers,
Terry