Regexp_replace help
| От | Chris Hoover |
|---|---|
| Тема | Regexp_replace help |
| Дата | |
| Msg-id | 18A99BB3-EB26-47A3-94D6-D951E984D982@aweber.com обсуждение исходный текст |
| Ответы |
Re: Regexp_replace help
Re: Regexp_replace help |
| Список | pgsql-admin |
Looking for some help here. I have a string that has ‘code1234’ in it. The 1234 can vary and I won’t know what they would be. Trying to figure out how to use regexp_replace to trim down the string, but unsure how to keep the ‘code1234’ in the string.
The search should be ‘ code[0-9]+? .*’. However, I don’t understand what the replace should be.
I.E.:
SELECT regexp_replace(’This is my test string that caused code12 from abc’,
‘ code[0-9]+? .*’,
‘What should this be so I keep the code12?‘)
Desire result:
’This is my test string that caused code12’
SELECT regexp_replace(’This is my second test string and it is causing code1234 from def. The weather is nice. :)’,
‘ code[0-9]+? .*’,
‘What should this be so I keep the code1234?’)
Desire result:
‘This is my second test string and it is causing code1234’
Thanks,
Chris Hoover
Senior DBA
AWeber.com
Cell: (803) 528-2269
Email: chrish@aweber.com
В списке pgsql-admin по дате отправления: