StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
3587005
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
2
CommunityOwnedDate
CreationDate
2010-08-27T18:13:30.373
FavoriteCount
0
LastActivityDate
2010-08-27T18:13:30.373
LastEditDate
LastEditorUserId
0
OwnerUserId
166258
ParentId
3586799
PostTypeId
2
Score
3
ViewCount
0
LastEditorDisplayName
text
Body
It's a little bit unclear how you intend to retrieve and store that data into a single VBA string, but if you are going to try to copy and paste the contents of the text you posted and have available in-memory as a string in VBA, here's how you might approach it. The biggest thing to remember is to escape your double quotes and line-breaks. I replaced all <code>"</code> with <code>" & chr(34) & "</code> and added a <code>vbCrLf</code> to the end of the line. The first few lines of your file might look like this when consumed in VBA: <pre><code>Public Sub TestString() Dim str As String str = "" str = str & "<svg " & vbCrLf str = str & " xmlns:dc=" & Chr(34) & "http://purl.org/dc/elements/1.1/" & Chr(34) & " " & vbCrLf str = str & " xmlns:cc=" & Chr(34) & "http://creativecommons.org/ns#" & Chr(34) & " " & vbCrLf str = str & " xmlns:rdf=" & Chr(34) & "http://www.w3.org/1999/02/22-rdf-syntax-ns#" & Chr(34) & " " & vbCrLf str = str & " xmlns:svg=" & Chr(34) & "http://www.w3.org/2000/svg" & Chr(34) & " " & vbCrLf str = str & " xmlns=" & Chr(34) & "http://www.w3.org/2000/svg" & Chr(34) & " " & vbCrLf str = str & " xmlns:sodipodi=" & Chr(34) & "http://sodipodi.sourceforge.net/DTD/sodipodi-0.dtd" & Chr(34) & " " & vbCrLf str = str & " xmlns:inkscape=" & Chr(34) & "http://www.inkscape.org/namespaces/inkscape" & Chr(34) & " " & vbCrLf str = str & " version=" & Chr(34) & "1.0" & Chr(34) & " " & vbCrLf str = str & " width=" & Chr(34) & "958.69" & Chr(34) & " " & vbCrLf str = str & " height=" & Chr(34) & "592.78998" & Chr(34) & " " & vbCrLf str = str & " id=" & Chr(34) & "svg2275" & Chr(34) & " " & vbCrLf str = str & " sodipodi:version=" & Chr(34) & "0.32" & Chr(34) & " " & vbCrLf Debug.Print str End Sub </code></pre> To make it easier to generate those lines of <code>str = str ...</code> code, I pasted your code into Excel and used the following Excel formula which allowed me to simply paste the resulting Excel-calculated text right into the VBA editor: <pre><code>="str = str & " & CHAR(34) & SUBSTITUTE(A1,CHAR(34),CHAR(34) & " & chr(34) & " & CHAR(34)) & CHAR(34) & " & vbCrLf" </code></pre> I tried pasting everything you had into VBA, but some of the lines of your original text were way too long (the lines with numbers) and took up multiple rows in the VBA editor. That can be fixed fairly simply by breaking up those lines into multiple <code>str = str & ...</code> lines, except without the <code>vbCrLf</code> at the end.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POvba: storing a long string in a variable with special characters
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USBen McCormack
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POvba: storing a long string in a variable with special characters
 singulars
 PostTypePostTypeId
 PTQuestion
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTAcceptedByOriginator
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. COBy the way, double quotes in VB/VBA can be escaped with another double-quote, so instead of `"height=" & Chr(34) & "592.78998" & Chr(34)` you can simply write `"height=""592.78998"""`.
 singulars
 PostPostId
 PO
 UserUserId
 USDirk Vollmar
2. CO@0xA3 very good point. I guess I use `chr(34)` since I learned to do that before I learned about escaping the double quotes. I also get confused by looking at lots of pairs of double quotes :-).
 singulars
 PostPostId
 PO
 UserUserId
 USBen McCormack

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.