We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Course Of The Month
4 days, 16 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
Why doesn't the Oracle optimizer use my index?
Querying too much data
Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table.
So, the obvious side…
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux.
Script may need to be modified depending on OS-installation.
Please deploy and verify the script in a test environment.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to take different types of Oracle backups using RMAN.
Suggested Courses
Course of the Month4 days, 16 hours left to enroll
Earn Certification
Certified Information Systems Auditor (CISA)
$99.00$89.10
688 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.