October 7, 2008 04:42pm pdt

1. chapmandew 2,223,259
2. angelIII 1,997,731
3. mark_wills 631,410
4. aneeshatti... 607,479
5. ScottPletc... 456,851
6. EugeneZ 366,402
7. ee_rlee 353,240
8. BrandonG... 340,310
9. acperkins 335,429
10. dtodd 304,879
11. momi_sa... 194,132
12. cs97jjm3 188,038
13. matthews... 169,999
14. appari 166,334
15. nmcdermaid 165,158
16. rickchild 165,060
17. brejk 163,902
18. dqmq 156,258
19. Thomasian 153,702
20. dportas 141,305
21. ptjcb 140,761
22. dbaSQL 139,392
23. bhess1 134,605
24. mwvisa1 128,997
25. MohammedU 125,975

1. angelIII 10,954,144
2. aneeshatti... 4,665,358
3. acperkins 4,323,889
4. ScottPletc... 4,270,903
5. arbert 2,245,195
6. chapmandew 2,223,259
7. Lowfatsp... 2,174,384
8. EugeneZ 1,642,564
9. imran_fast 1,482,261
10. rafrancisco 1,460,132
11. Hilaire 1,221,775
12. nmcdermaid 1,149,742
13. Nightman 1,146,504
14. Mr_Peer... 1,087,815
15. ptjcb 1,074,620
16. bhess1 1,071,597
17. dtodd 891,222
18. adathelad 777,208
19. Sirees 776,352
20. appari 753,571
21. BriCrowe 722,959
22. matthews... 692,331
23. amit_g 683,229
24. mark_wills 631,410
25. ShogunW... 619,598

03.26.2008 at 01:32PM PDT, ID: 23272014

	[x] Attachment Details

TSQL to convert HTML (as ntext) to non-html text?

Asked by volking in MS SQL Server

Anyone have TSQL script to convert an HTML (in an ntext column) to just plain text? If not, then I'm probably gonna'hafta write one. Arrrrrgh ... Not just stripping all <tag> stuff but intelligent replacement, too.

things like ....
<BR/> and <P></P> with CrLf's
< > with < and >
maybe even converting stuff like <UL> and <LI> into tab indented text?

Anyone got any ideas? There's a lot of little programs out there but I need something that works in a plain old TSQL script!Start Free Trial

Keywords: TSQL to convert HTML (as ntext) to …

	Title
1	tsql insert trigger inserting BEFORE the…
2	Eliminating UL indents
3	Surpress a <UL> indent ?
4	XML encoding < and >
5	Unordered List - Indentation
6	<UL> Question

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628

TSQL to convert HTML (as ntext) to non-html text?

Asked by volking in MS SQL Server

About this solution