Date: 02/10/05 (SQL Server)    Keywords: php, html, sql, web

My boss called me over and asked me to write a T-SQL function on behalf of our web guy, that would arbitrarily strip out all HTML tags from a VARCHAR. In any other language like PHP, Perl, etc., I'd employ Regular Expressions to do this globally. However, T-SQL only really has PATINDEX and CHARINDEX, those aren't all that powerful.

I did wind up coming up with an iterative solution, which I thought I'd share with everyone to get suggestions and feedback.



CREATE TABLE #tmpText (
id INT IDENTITY(1, 1),
data varchar(4000)
)

INSERT INTO #tmpText (data)
VALUES ('this is some html')

INSERT #tmpText VALUES (
'


SOME HTML text after the body'
)

INSERT #tmpText VALUES (
'

Another HTML text after the body'
)

-- WHILE a '<' and '>' pair are present and the former's position is less than the latter's position value
-- Find a '<' then the next '>' positions, and run a stuff to remove whatever's in between!

BEGIN TRANSACTION
WHILE EXISTS (SELECT 1
FROM #tmpText
WHERE PATINDEX('%<%>%', data) > 0
)
BEGIN
UPDATE #tmpText
SET data = STUFF(data, PATINDEX('%<%>%', data), CHARINDEX('>', data) - PATINDEX('%<%>%', data) + 1, '')
WHERE PATINDEX('%<%>%', data) > 0
END

SELECT *
FROM #tmpText

ROLLBACK



I'm going to keep trying to dissect this in order to come up with a cleaner, non-iterative solution. If anyone else already has a function that does this in one fell-swoop, rather than via looping, PLEASE share it! :-)

UPDATE: I've made further code changes to handle a few odd circumstances and have finished the function. Thought I'd share it with everyone for a "peer review." Please comment away!


ALTER FUNCTION uf_stripHTML
(
   @strHTML varchar(8000),
   @flgFormat int = 1
)
RETURNS varchar(8000)
AS
BEGIN

--------------------------------------------------------------------------------------------------
-- Date Written: 02-10-2005
-- Purpose: Arbitrarily strip all text between all pairs of < > tags. This SHOULD be
-- HTML but theoretically could be other data?
----------------------------------------------------------------------------------------------------
-- Input Parameters: @strHTML = The string that we are stripping HTML from.
-- @flgFormat = If set to 1 (DEFAULT), then the function will attempt to
-- preserve basic formatting by detecting non-breaking spaces, start and end
-- paragraph tags, and break-return tags, and replacing them with their
-- ASCII equivalents.
----------------------------------------------------------------------------------------------------
-- Comments: This solution employs an iterative algorithm to repeatedly sweep through
-- the variable's text, removing HTML tags one at a time.
----------------------------------------------------------------------------------------------------

DECLARE @ltPosition int

-- If flgFormat is 1, then replace pre-determined list of tags and characters with
-- corresponding values!
IF @flgFormat = 1
BEGIN
   SET @strHTML = REPLACE(@strHTML, '

', CHAR(10) + CHAR(13))
   SET @strHTML = REPLACE(@strHTML, '

Source: http://www.livejournal.com/community/sqlserver/17939.html

Date: 03/02/05 (HTML Help)    Keywords: html

I was wondering if anyone could help me fix my layout (well the html in it) so that it shows up in Firefox. It shows up in internet explorer but not in firefox. I'd appreciate any help.
Thanks!!

Source: http://www.livejournal.com/community/htmlhelp/1812288.html

Date: 03/03/05 (PHP Community)    Keywords: php, html, web

All my php scripts or pages ending in PHP are not available to see. I get a 403 error saying...


You are not authorized to view this page
You might not have permission to view this directory or page using the credentials you supplied.

--------------------------------------------------------------------------------

If you believe you should be able to view this directory or page, please try to contact the Web site by using any e-mail address or phone number that may be listed on the www.cakesbytammy.com home page.

You can click Search to look for information on the Internet.




HTTP Error 403 - Forbidden
Internet Explorer


I also get this when I type in her domain name, minus the specific HTML file. suchas http://www.somedomain.com/ Any suggestions as to WTF is going on?!??!

Source: http://www.livejournal.com/community/php/269157.html

Date: 03/04/05 (WebDesign)    Keywords: php, programming, css, html

i doubt you can do this.. but i was wondering if there was a way to use any sort of programming to text wrap between 2 columns.

i have a page with 2 columns of text, side by side, and i don't want the white space at the bottom. however, since text is displayed differently on different platforms [mac and pc] i have to just leave it and increase the padding an paragraph set up specifically for the pc. i still have the white space and i can't stand it.

so, i was wondering if anyone knew of any code to text wrap in html, css, js, php - anything - between columns.

thanks :]

Source: http://www.livejournal.com/community/webdesign/820379.html

Date: 03/04/05 (Web Development)    Keywords: css, html, web

Hey all:

I was wondering if anyone could recommend me a good intro to XHTML and CSS. I want to get a book that will put me on the right path to 'intelligent' web design. That is, I want to design good sites, not only in appearance but in structure as well.

Thanks

Source: http://www.livejournal.com/community/webdev/177143.html

Date: 03/05/05 (HTML Help)    Keywords: html

hey, i'm new here. not really new to html but i don't know how to do something and I hope someone here can help. the site i'm working on is http://tearsforthedying.com.

I'd like the background to remain fixed have the text scroll as needed. But.. I have image rollovers that are part of the background - I don't want to kill those.

Can I still used a fixed background with rollovers such as I now have?

thanks!

Source: http://www.livejournal.com/community/htmlhelp/1818700.html

Date: 03/05/05 (HTML Help)    Keywords: html

Two questions:

1. Does anyone know any links to where I can learn Myspace HTML?
2. Can someone tell me the code to change the links on Myspace so that it Capitalizes itself?

Thanks in advance <33

Source: http://www.livejournal.com/community/htmlhelp/1819283.html

Date: 03/05/05 (HTML Help)    Keywords: html

Is there anyone out there who's really really good at HTML who wouldn't mind helping? =\ I need help with my userinfo because I put in those little table boxes but I can't get my text centered [see _azzybear] and I would really like some help. I would absolutely credit you and/or your community if you have one, please?! Thank you. <3

Source: http://www.livejournal.com/community/htmlhelp/1818950.html

Date: 03/06/05 (Web Development)    Keywords: cms, html, web

Hey everyone, I'm looking for a free CMS for my website.

Basically, I want it to do two things. 1) I want it to fit the form I have right now as close as it can, and 2) I want it to archive my posts for viewing later.

http://www.thisisjerkass.com

I'm willing to comprimise a little bit when it comes to the site layout, but I'm looking for something that would be kinda easy for my co-webmasters. There's three of us and one of us is an html novice.

One final requirement: free. I know I'm asking for a lot, but I figured if anyone could help, it'd be you guys.

Thanks in advance.

Source: http://www.livejournal.com/community/webdev/177383.html

Date: 03/06/05 (See my site)    Keywords: html

Source: http://www.livejournal.com/community/see_my_site/79116.html

Date: 03/07/05 (WebDesign)    Keywords: html, web

I have some knowledge of HTML. In fact, I made my first website (which I never posted on the internet) in HTML. Wasn't very pretty, but it was a good start. The best HTML editor would have to be HTMLed 3.2 (not the Pro). I think the non-pro one is free. It has syntax highlighting and all that jazz.

Does anyone else here have knowledge of HTML?

Source: http://www.livejournal.com/community/webdesign/822921.html

Date: 03/07/05 (Computer Geeks)    Keywords: html, google

Is GMail b0rked for anyone else?
When I try and log into it all I get is IE (I'm at work) trying to download hist1.html from gmail.google.com.

Source: http://www.livejournal.com/community/computergeeks/624763.html

Date: 03/08/05 (HTML Help)    Keywords: html

Maybe not a "HTML" question per se, but how can I save my LJ user pictures? Everytime I go to save them, it saves them as bitmap, and not GIF, and they turn to an image. Any help is very much appreciated!

Source: http://www.livejournal.com/community/htmlhelp/1828068.html

Date: 03/08/05 (Computer Geeks)    Keywords: html, google

http://www.google-watch.org/gmail.html

Source: http://www.livejournal.com/community/computergeeks/625840.html

Date: 03/09/05 (HTML Help)    Keywords: software, html, java, web

Could someone provide me with some html code for this?

#1: I would like to make a html form on a website that would create new pages from that form containing that form's information. (Very simple html form code of some sort. I've done this in the past, but forgot how to do it.)

#2 (much more complicated. If it requires outside software other than java, forget it.): I would like to make a html form on a website that would create new pages that look identical to the original form, but with the blanks and buttons replaced with the form data submitted. Ideally, you would NOT be able to click any radio button or place a blinking cursor in any blank already filled with information.

Source: http://www.livejournal.com/community/htmlhelp/1831170.html