Pattern-match & Replace - help required

[AT]

Hi,

I am new to python and web2py framework. Need urgent help to match a pattern in an string and replace the matched text.

I've this string (basically an sql statement):
stmnt = 'SELECT taxpayer.id,
taxpayer.enc_name,
taxpayer.age,
taxpayer.occupation
FROM taxpayer WHERE (taxpayer.id IS NOT NULL);'

The requirement is to replace it with this one:
r_stmnt = 'SELECT taxpayer.id,
decrypt(taxpayer.enc_name),
taxpayer.age,
taxpayer.occupation
FROM taxpayer WHERE (taxpayer.id IS NOT NULL);'

Can somebody please help?

Thanks & Regards

 

[Steven D'Aprano]

Hi,

I am new to python and web2py framework. Need urgent help to match a
pattern in an string and replace the matched text.

I've this string (basically an sql statement):

stmnt = 'SELECT taxpayer.id,
taxpayer.enc_name,
taxpayer.age,
taxpayer.occupation
FROM taxpayer WHERE (taxpayer.id IS NOT NULL);'

The requirement is to replace it with this one:

r_stmnt = 'SELECT taxpayer.id,
decrypt(taxpayer.enc_name),
taxpayer.age,
taxpayer.occupation
FROM taxpayer WHERE (taxpayer.id IS NOT NULL);'

Can somebody please help?

Can you do this?

stmnt = r_stmnt

That should do what you are asking.

If that doesn't solve your problem, you will need to explain your problem
in more detail.

 

[AT]

Can you do this?



stmnt = r_stmnt



That should do what you are asking.



If that doesn't solve your problem, you will need to explain your problem

in more detail.

I just wanted to change taxpayer.enc_name in stmnt to decrypt(taxpayer.enc_name)

hope it clarifies?

thanks

 

[Steven D'Aprano]

I just wanted to change taxpayer.enc_name in stmnt to
decrypt(taxpayer.enc_name)

hope it clarifies?

Maybe. Does this help?

lunch = "Bread, ham, cheese and tomato."
# replace ham with spam
offset = lunch.find('ham')
if offset != -1:
lunch = lunch[ffset] + 'spam' + lunch[offset + len('ham'):]
print(lunch)

 

[Thomas Bach]

Hi,

I am new to python and web2py framework. Need urgent help to match a
pattern in an string and replace the matched text.

Well, what about str.replace then?
'egg, spam, ham, spam, tomato'


If the pattern you want to match is more complicated, have a look at
the re module!

Regards,
Thomas.

 

[AT]

Well, what about str.replace then?




'egg, spam, ham, spam, tomato'





If the pattern you want to match is more complicated, have a look at

the re module!



Regards,

Thomas.

The pattern is '%s.enc_%s', and after matching this pattern want to change it to 'decrypt(%s.enc_%s)'

Thanks

 

[AT]

Well, what about str.replace then?




'egg, spam, ham, spam, tomato'





If the pattern you want to match is more complicated, have a look at

the re module!



Regards,

Thomas.

The pattern is '%s.enc_%s', and after matching this pattern want to change it to 'decrypt(%s.enc_%s)'

Thanks

 

[Peter Otten]

I am new to python and web2py framework. Need urgent help to match a
pattern in an string and replace the matched text.

I've this string (basically an sql statement):
stmnt = 'SELECT taxpayer.id,
taxpayer.enc_name,
taxpayer.age,
taxpayer.occupation
FROM taxpayer WHERE (taxpayer.id IS NOT NULL);'

The requirement is to replace it with this one:
r_stmnt = 'SELECT taxpayer.id,
decrypt(taxpayer.enc_name),
taxpayer.age,
taxpayer.occupation
FROM taxpayer WHERE (taxpayer.id IS NOT NULL);'

Can somebody please help?

The pattern is '%s.enc_%s', and after matching this pattern want to change
it to 'decrypt(%s.enc_%s)'

after = re.compile(r"(\w+[.]enc_\w+)").sub(r"decrypt(\1)", before)

 

[AT]

AT wrote:

I am new to python and web2py framework. Need urgent help to match a

pattern in an string and replace the matched text.

I've this string (basically an sql statement):

stmnt = 'SELECT taxpayer.id,



FROM taxpayer WHERE (taxpayer.id IS NOT NULL);'

The requirement is to replace it with this one:

r_stmnt = 'SELECT taxpayer.id,



FROM taxpayer WHERE (taxpayer.id IS NOT NULL);'

Can somebody please help?


The pattern is '%s.enc_%s', and after matching this pattern want to change

it to 'decrypt(%s.enc_%s)'

after = re.compile(r"(\w+[.]enc_\w+)").sub(r"decrypt(\1)", before)

Thanks a million
Can you recommend a good online book/tutorial on regular expr. in python?

Regards

 

[AT]

AT wrote:

I am new to python and web2py framework. Need urgent help to match a

pattern in an string and replace the matched text.

I've this string (basically an sql statement):

stmnt = 'SELECT taxpayer.id,



FROM taxpayer WHERE (taxpayer.id IS NOT NULL);'

The requirement is to replace it with this one:

r_stmnt = 'SELECT taxpayer.id,



FROM taxpayer WHERE (taxpayer.id IS NOT NULL);'

Can somebody please help?


The pattern is '%s.enc_%s', and after matching this pattern want to change

it to 'decrypt(%s.enc_%s)'

after = re.compile(r"(\w+[.]enc_\w+)").sub(r"decrypt(\1)", before)

Thanks a million
Can you recommend a good online book/tutorial on regular expr. in python?

Regards

 

[Alexander Blinne]

Am 19.12.2012 14:41, schrieb AT:

Thanks a million
Can you recommend a good online book/tutorial on regular expr. in python?

http://docs.python.org/3/howto/regex.html

 

[MRAB]

Am 19.12.2012 14:41, schrieb AT:

http://docs.python.org/3/howto/regex.html

Another good resource is:

http://www.regular-expressions.info/