Replace part of the string matching the pattern

Question

It's my first Python day, so please excuse me for this question

The Problem: in a file replace every occurrence of trim(column_name) with TRIM (TRIM (CHR (09) FROM column_name)). I've already sorted out how to do a pattern search and acquainted myself with the re.sub() function.

the pattern that matches my case is

p = re.compile ('trim\([a-z0-9_]+\)',re.I)

but how do I replace the matching pattern preserving the column name???

The needed output is, for example, as follows:

input: select trim(API12), trim(FIELD_CODE) from table
output: select TRIM (TRIM (CHR (09) FROM API12)), TRIM (TRIM (CHR (09) FROM FIELD_CODE)) from table

I think this answer will be helpful http://stackoverflow.com/questions/3997525/python-replace-with-regex — Andrii Rusanov, Feb 21 '14 at 09:38

score 1 · Answer 1 · answered Feb 21 '14 at 09:44

1

import re
s = 'select trim(API12), trim(FIELD_CODE) from table'
print re.sub(r'trim\((?P<col>[a-zA-Z0-9_]+)\)', 'TRIM (TRIM (CHR (09) FROM \g<col>))', s)

answered Feb 21 '14 at 09:44

Jayanth Koushik

9,476
1
44
52

score 1 · Accepted Answer · answered Feb 21 '14 at 09:50

Working code:

import re
i = 'select trim(API12), trim(FIELD_CODE) from table'
re.sub(r"trim\((\w+)\)", r"TRIM (TRIM (CHR (09) FROM \1))", i)

Explain

You don't have to use flag re.I, use \w instead, it's equivalence to [a-zA-Z0-9_].
\(\) means the normal parenthesis, () means the grouping
use \1 to render the first match group, \2 for second one.

score 0 · Answer 3 · answered Feb 21 '14 at 09:52

I've just sorted this one out for myself

Thanks for your help!

import re

line = "select trim(API12), trim(FIELD_CODE) from dual"

output = re.sub(r'trim\(([a-zA-Z0-9_]+)\)',r'TRIM (TRIM (CHR (09) FROM\1))',line)

print output

>> select TRIM (TRIM (CHR (09) FROM API12)), TRIM (TRIM (CHR (09) FROM FIELD_CODE)) from dual

Replace part of the string matching the pattern

3 Answers3

Explain