Replace several abbreviations in a string
292515Jan 22 2009 — edited Jan 23 2009Hi,
I find no solution to replace more than one abbreviation in a string at once.
I have a table a with an attribute 'name' which contains some abbrevations e. g. 'article no. s. p.'.
I have a table with abbreviations b with the columns 'abbreviation' and 'replace_string' e. g.
no. | number
s. | section
p. | page
Now I want to replace all abbreviations in 'name' with the correct replace_string e. g.
'article no. s. p.' -> 'article number section page'
Can anybody give me a hint how to do this?
Regards,
Detlef