Nowadays, monitoring is a mixture of tools, systems, and codes—making it a very complex process. And with this complexity, comes variables for failure. Get DZone’s new Guide to Performance to learn how to proactively find these variables and solve them before a disruption occurs.
Course Of The Month
6 days, 10 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Oracle procedure question related to ID: 27979957
Posted on 2013-01-07
I had a question answered for parsing characters out of a string etc....I want to enhance this query further. I found that in certain circumstances there is a part of a string that starts with { , has text after it, and ends with a }....What I need to do is take this whole portion out of the text being returned. Below is the function that I need this logic added too, if I can....
regexp_replace(col1,'[^a-z
Example of data:
Jones played '~(`|¤|football)~' and baseball at '~(¦%|¥|Mobile County Training School)~' in '~(`|¤|{link:10098}|Mobile
The above function will return this
Jones played football and baseball at Mobile County Training School in {link:10098} Mobile, Alabama, and Alabama A&M University.
I need everything between { and } , including the curly brackets, removed...
Thanks
JK
regexp_replace(col1,'[^a-z
Example of data:
Jones played '~(`|¤|football)~' and baseball at '~(¦%|¥|Mobile County Training School)~' in '~(`|¤|{link:10098}|Mobile
The above function will return this
Jones played football and baseball at Mobile County Training School in {link:10098} Mobile, Alabama, and Alabama A&M University.
I need everything between { and } , including the curly brackets, removed...
Thanks
JK
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
3
2
5 Comments
Active today
See if this is what you are after:
select regexp_replace(col1,'{.*}|
select regexp_replace(col1,'{.*}|
Active 1 day ago
Yes that worked but I do have a question before I finish this. I need to keep certain characters in the text field like periods and back slashes, etc... Is there any way I can include what characters to keep and not get rid of?
Active 1 day ago
Actually I just included the characters in the 2nd argument and it worked. I think Im good....For now anyways...
Active today
>>Is there any way I can include what characters to keep and not get rid of?
Yes. I mentioned this in the previous questions, just add the characters you want to keep to the list inside the square brackets (the '-' MUST be the last one in the list): [^a-zA-Z0-9: ' || chr(10) || chr(13)|| '-]
The potential issue is if the 'keep' characters are part of the string in the 'special' characters you want to remove.
If you run into this, we may need a more complex regular expression.
Keep a list of the edge case's data and if you need to ask a new question, provide ALL the sample data and expected results for each.
Yes. I mentioned this in the previous questions, just add the characters you want to keep to the list inside the square brackets (the '-' MUST be the last one in the list): [^a-zA-Z0-9: ' || chr(10) || chr(13)|| '-]
The potential issue is if the 'keep' characters are part of the string in the 'special' characters you want to remove.
If you run into this, we may need a more complex regular expression.
Keep a list of the edge case's data and if you need to ask a new question, provide ALL the sample data and expected results for each.
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
This article describes how to use the timestamp of existing data in a database to allow Tableau to calculate the prior work day instead of relying on case statements or if statements to calculate the days of the week.
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows syntax for various backup options while discussing how the different basic backup types work. It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
Suggested Courses
Course of the Month6 days, 10 hours left to enroll
Earn Certification
Certified Information Systems Auditor (CISA)
$99.00$89.10
726 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.