html in database string
- Thread starter UKSBD
- Start date
Not without another mechanism coded to sort out that problem.
You could do it this way though:
create table p {
id BIGINT PRIMARY KEY AUTOINCREMENT,
value TEXT
}
then you pull as many characters as you like, but supply the start and end tag.
select '<p>' || substring( p.value, from 1, for 255 ) || '</p>' from p where id = 1;
|| is a concatenation, and the syntax is postgresql but you should be able to translate into whatever.
If a value contains HTML markup though, then it may still not work. You would need the value to be text, etc. You could filter after perhaps, or build a function to scan for markup and drop it.
You could do it this way though:
create table p {
id BIGINT PRIMARY KEY AUTOINCREMENT,
value TEXT
}
then you pull as many characters as you like, but supply the start and end tag.
select '<p>' || substring( p.value, from 1, for 255 ) || '</p>' from p where id = 1;
|| is a concatenation, and the syntax is postgresql but you should be able to translate into whatever.
If a value contains HTML markup though, then it may still not work. You would need the value to be text, etc. You could filter after perhaps, or build a function to scan for markup and drop it.
Upvote
0
Are you allowing all types of HTML or only certain tags like <h1> and <b> etc?
If you are allowing a totally free hand then it is going to be difficult to pull out only the first X characters and ensure that it still displays correctly etc as you may pull out half the first row of a table etc.
Is the intention to give a summary? if it is then generally would strip all HTML from it and have it as plain text or allow users to write their own summary and only allow basic HTML tags
If you are allowing a totally free hand then it is going to be difficult to pull out only the first X characters and ensure that it still displays correctly etc as you may pull out half the first row of a table etc.
Is the intention to give a summary? if it is then generally would strip all HTML from it and have it as plain text or allow users to write their own summary and only allow basic HTML tags
Upvote
0
- Original Poster
- #4
Yes it is all HTML
I was wondering if it is possible to pull it from the database as a html page
but then copy as plain text and create a 2nd field/string in the database, then use some of that for a summary.
I.e
as though right clicking over the text and copying, so it copies as plain
text even thoufg there are links in the text.
Is that possible?
I was wondering if it is possible to pull it from the database as a html page
but then copy as plain text and create a 2nd field/string in the database, then use some of that for a summary.
I.e
as though right clicking over the text and copying, so it copies as plain
text even thoufg there are links in the text.
Is that possible?
Upvote
0
You could use a regexp to take out any tags.
s/<[^>]*>//g
asp should have a regex replace function (you may need to change the syntax a little).
Effectively you filter it in the database or via asp, whichever you find easier, database would probably be a little quicker though.
s/<[^>]*>//g
asp should have a regex replace function (you may need to change the syntax a little).
Effectively you filter it in the database or via asp, whichever you find easier, database would probably be a little quicker though.
Last edited:
Upvote
0
Similar threads
Latest Articles
-
Growth Britain: what's actually in it for the smallest businesses?John Healey gave his first big speech as chancellor this morning, standing in front of a row of...- Ozzy
- Updated:
- 7 min read
-
AI can do the typing. It can't sign the accounts.Back in January, a UKBF member called @Byzantium put up a complaint that'll sound familiar to a...- Lord Moore
- Updated:
- 6 min read
-
90,000 jobs are heading your way. Your rates bill might get there firstIf you run a business in Manchester, Birmingham, Leeds or Bristol, you were probably told some...
- Ozzy
- Updated:
- 8 min read
-
How to Price a New Product or Service: We Asked UKBFOn 5 August, @Data Swami posted in the General Business Forum with a question that ought to have...
- Ozzy
- Updated:
- 7 min read
-
70 years of director bans in six months: Companies House has stopped asking nicelyCompanies House published a release on August 6th 2026 that every company director should read...
- Ozzy
- Updated:
- 7 min read