FREE Tutorials on HTML XHTML CSS JavaScript XML XSL ASP SQL ADOVBScript, SAP - ABAP

[univbgp100]

##FREE Tutorials on HTML XHTML CSS JavaScript XML XSL ASP SQL ADO
VBScript, SAP - ABAP

FREE Tutorials on HTML XHTML CSS JavaScript XML XSL ASP SQL ADO
VBScript, SAP - ABAP visit ebooks.univdatabase.com

 

[Ahmed, Shakir]

I have thousands of records in MS Access database table, which records I
am fetching using python script. One of the columns having string like
'8 58-2155-58'

Desired output: '858215558'

I want to remove any spaces between string and any dashes between
strings. I could do it in access manually but want to do from python
script

Any help is highly appreciated.

sh

 

[s0suk3]

I have thousands of records in MS Access database table, which records I
am fetching using python script. One of the columns having string like
'8 58-2155-58'

Desired output: '858215558'

I want to remove any spaces between string and any dashes between
strings. I could do it in access manually but want to do from python
script

Any help is highly appreciated.

string.replace('-', '').replace(' ', '')

 

[Ahmed, Shakir]

Thanks, works exactly what I needed.

-----Original Message-----
From: [email protected]
[mailto[email protected]] On Behalf Of
(e-mail address removed)
Sent: Tuesday, May 20, 2008 12:22 PM
To: (e-mail address removed)
Subject: Re: Removing Space and "-" from a string

I have thousands of records in MS Access database table, which records I
am fetching using python script. One of the columns having string like
'8 58-2155-58'

Desired output: '858215558'

I want to remove any spaces between string and any dashes between
strings. I could do it in access manually but want to do from python
script

Any help is highly appreciated.

string.replace('-', '').replace(' ', '')

 

[Paul Hankin]

I have thousands of records in MS Access database table, which records I
am fetching using python script. One of the columns having string like
'8 58-2155-58'

Desired output: '858215558'

I want to remove any spaces between string and any dashes between
strings. I could do it in access manually but want to do from python
script

'filter' returns a string if it's argument is a string, so works
nicely here.

def cleanup(s):
return filter(lambda x: x not in ' -', s)

 

[Terry Reedy]

I have thousands of records in MS Access database table, which records I
am fetching using python script. One of the columns having string like
'8 58-2155-58'

Desired output: '858215558'

|def cleanup(s):
| return filter(lambda x: x not in ' -', s)

Or'858215558'