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]

Brad Tilley wrote:

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.

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

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

Kent

or....

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

[Dave Reed]

On Sunday 07 November 2004 20:02, Brad Tilley wrote:

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]

Kent Johnson wrote:

Brad Tilley wrote:

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

Thanks Kent, this works great.

[Scott David Daniels]

Kent Johnson wrote:

Brad Tilley wrote:

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)

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

-Scott David Daniels
Scott.DanielsAc m.Org

[Terry Hancock]

On Sunday 07 November 2004 07:02 pm, Brad Tilley wrote:

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

--
Terry Hancock ( hancock at anansispacework s.com )
Anansi Spaceworks http://www.anansispaceworks.com