Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.
COURSE of the MONTH
10 days, 2 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
regex replace
Posted on 2014-11-06
Hi
I'm trying to remove bullet points from an HTML field using ...............
ltrim(regexp_replace(regex
However, I'm still getting some whitespace at the beginning of each line in my text field where the next bullet point was - how can I remove this - if possible?
FYI - I am using this field in Crystal Reports where I can see this leading whitespace eg
This was the first bullet point and nicely aligned to the left.
This was the second bullet point and NOT nicely aligned to the left.
This was the third bullet point and NOT nicely aligned to the left ..etc
Regards
I'm trying to remove bullet points from an HTML field using ...............
ltrim(regexp_replace(regex
However, I'm still getting some whitespace at the beginning of each line in my text field where the next bullet point was - how can I remove this - if possible?
FYI - I am using this field in Crystal Reports where I can see this leading whitespace eg
This was the first bullet point and nicely aligned to the left.
This was the second bullet point and NOT nicely aligned to the left.
This was the third bullet point and NOT nicely aligned to the left ..etc
Regards
[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 Comments
Active today
First:
No need for regexp_replace since you really aren't using any regular expressions. A simple replace should work.
Now, eliminate crystal reports to figure out where the spaces are.
I typically concatenate a value to both sides and run in sqlplus:
select ':' || some_value || ':' from some_table;
Then I can see if the space is in the value by looking at the colons. This will tell you if the issue is in the data or in Crystal.
No need for regexp_replace since you really aren't using any regular expressions. A simple replace should work.
Now, eliminate crystal reports to figure out where the spaces are.
I typically concatenate a value to both sides and run in sqlplus:
select ':' || some_value || ':' from some_table;
Then I can see if the space is in the value by looking at the colons. This will tell you if the issue is in the data or in Crystal.
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime? I'm talking things like:
* Dropping columns
* Shrinking allocated space
* Removing chained blocks and restoring the PCTFREE
* Re-or…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax:
(CODE)
This way, I guessed, I would ensure that use…
This video shows how to copy a database user from one database to another user DBMS_METADATA. It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
Via a live example, show how to take different types of Oracle backups using RMAN.
Suggested Courses
Course of the Month10 days, 2 hours left to enroll
762 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.