StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
5874243
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
3
CommunityOwnedDate
CreationDate
2011-05-03T18:54:37.750
FavoriteCount
0
LastActivityDate
2015-05-07T11:14:59.017
LastEditDate
2015-05-07T11:14:59.017
LastEditorUserId
471026
OwnerUserId
471026
ParentId
5872982
PostTypeId
2
Score
9
ViewCount
0
LastEditorDisplayName
text
Body
<p>Recently I was looking for similar thing after bit of googling I found a nice function. It has most of the <strong>bad</strong> tags listed. here is the link which contains that function: </p> <p>Javascript Function</p> <pre><code><script type="text/javascript" runat="server" language="javascript"> function CleanWordHTML( str ) { str = str.replace(/<o:p>\s*<\/o:p>/g, "") ; str = str.replace(/<o:p>.*?<\/o:p>/g, "&nbsp;") ; str = str.replace( /\s*mso-[^:]+:[^;"]+;?/gi, "" ) ; str = str.replace( /\s*MARGIN: 0cm 0cm 0pt\s*;/gi, "" ) ; str = str.replace( /\s*MARGIN: 0cm 0cm 0pt\s*"/gi, "\"" ) ; str = str.replace( /\s*TEXT-INDENT: 0cm\s*;/gi, "" ) ; str = str.replace( /\s*TEXT-INDENT: 0cm\s*"/gi, "\"" ) ; str = str.replace( /\s*TEXT-ALIGN: [^\s;]+;?"/gi, "\"" ) ; str = str.replace( /\s*PAGE-BREAK-BEFORE: [^\s;]+;?"/gi, "\"" ) ; str = str.replace( /\s*FONT-VARIANT: [^\s;]+;?"/gi, "\"" ) ; str = str.replace( /\s*tab-stops:[^;"]*;?/gi, "" ) ; str = str.replace( /\s*tab-stops:[^"]*/gi, "" ) ; str = str.replace( /\s*face="[^"]*"/gi, "" ) ; str = str.replace( /\s*face=[^ >]*/gi, "" ) ; str = str.replace( /\s*FONT-FAMILY:[^;"]*;?/gi, "" ) ; str = str.replace(/<(\w[^>]*) class=([^ |>]*)([^>]*)/gi, "<$1$3") ; str = str.replace( /<(\w[^>]*) style="([^\"]*)"([^>]*)/gi, "<$1$3" ) ; str = str.replace( /\s*style="\s*"/gi, '' ) ; str = str.replace( /<SPAN\s*[^>]*>\s*&nbsp;\s*<\/SPAN>/gi, '&nbsp;' ) ; str = str.replace( /<SPAN\s*[^>]*><\/SPAN>/gi, '' ) ; str = str.replace(/<(\w[^>]*) lang=([^ |>]*)([^>]*)/gi, "<$1$3") ; str = str.replace( /<SPAN\s*>(.*?)<\/SPAN>/gi, '$1' ) ; str = str.replace( /<FONT\s*>(.*?)<\/FONT>/gi, '$1' ) ; str = str.replace(/<\\?\?xml[^>]*>/gi, "") ; str = str.replace(/<\/?\w+:[^>]*>/gi, "") ; str = str.replace( /<H\d>\s*<\/H\d>/gi, '' ) ; str = str.replace( /<H1([^>]*)>/gi, '' ) ; str = str.replace( /<H2([^>]*)>/gi, '' ) ; str = str.replace( /<H3([^>]*)>/gi, '' ) ; str = str.replace( /<H4([^>]*)>/gi, '' ) ; str = str.replace( /<H5([^>]*)>/gi, '' ) ; str = str.replace( /<H6([^>]*)>/gi, '' ) ; str = str.replace( /<\/H\d>/gi, '<br>' ) ; //remove this to take out breaks where Heading tags were str = str.replace( /<(U|I|STRIKE)>&nbsp;<\/\1>/g, '&nbsp;' ) ; str = str.replace( /<(B|b)>&nbsp;<\/\b|B>/g, '' ) ; str = str.replace( /<([^\s>]+)[^>]*>\s*<\/\1>/g, '' ) ; str = str.replace( /<([^\s>]+)[^>]*>\s*<\/\1>/g, '' ) ; str = str.replace( /<([^\s>]+)[^>]*>\s*<\/\1>/g, '' ) ; //some RegEx code for the picky browsers var re = new RegExp("(<P)([^>]*>.*?)(<\/P>)","gi") ; str = str.replace( re, "<div$2</div>" ) ; var re2 = new RegExp("(<font|<FONT)([^*>]*>.*?)(<\/FONT>|<\/font>)","gi") ; str = str.replace( re2, "<div$2</div>") ; str = str.replace( /size|SIZE = ([\d]{1})/g, '' ) ; return str ; } </script> </code></pre> <p><a href="http://www.1stclassmedia.co.uk/developers/clean-ms-word-formatting.php" rel="nofollow noreferrer">http://www.1stclassmedia.co.uk/developers/clean-ms-word-formatting.php</a></p> <p>all credits to original author.</p>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POPasting From MS-Word into any Browser-based HTML Editor
  singulars
  PostTypePostTypeId
  PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USZeNo
UserOwnerUserId
1. USZeNo
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
  singulars
  PostPostId
  PO
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTUpMod
2. VO
  singulars
  PostPostId
  PO
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTUpMod
3. VO
  singulars
  PostPostId
  PO
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTUpMod
CommentsPostId
1. CONot a bad start. Will see what others have to say, but helped a bit, so gave you an up-vote.
  singulars
  PostPostId
  PO
  UserUserId
  USOneNerd
2. CO@zeNo Working fine for Firefox/Chrome but in IE its adding additional "<" tag don't know why, Is there any specific settings/changes for IE only?
  singulars
  PostPostId
  PO
  UserUserId
  USGurvinder

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.