StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POGenerating autosorted HTML tables from text file?
primarykey
Id
4667816
data
AcceptedAnswerId
4667994
AnswerCount
3
ClosedDate
CommentCount
4
CommunityOwnedDate
CreationDate
2011-01-12T10:40:46.993
FavoriteCount
0
LastActivityDate
2011-01-12T18:51:34.763
LastEditDate
2017-05-23T11:55:28.840
LastEditorUserId
-1
OwnerUserId
273875
ParentId
0
PostTypeId
1
Score
2
ViewCount
1402
LastEditorDisplayName
text
Body
Update So I managed to get my table generated using <a href="https://stackoverflow.com/questions/4667816/generating-autosorted-html-tables-from-text-file/4667994#4667994">gabel's</a> suggestion with a few minor issues. This was especially useful since my colleague only has to edit a .CSV file in Excel. Due to presentation reasons, she now wants the table to look like so: <pre><code>------------------------------ | FRUITS | VEGGIES | ------------------------------ | Banana | Potato | ------------------------------ | Cherry | Pumpkin | ------------------------------ | Orange | Okra | ------------------------------ | MEATS | CARBS | ------------------------------ | Chicken | Bread | ------------------------------ | Beef | Rice | ------------------------------ | Pork | | ------------------------------ </code></pre> There are two <code>thead</code> entries or perhaps two tables but the .CSV file would still be: <pre><code>FRUITS,VEGGIES,MEATS,CARBS Banana,Potato,Chicken,Bread ... </code></pre> Questions <ol> <li>How would I parse the CSV file that it would break after the second comma and then create a new table or a new header/body set within the same table?</li> </ol> <hr> There's a HTML table I'd like to have generated with as little work possible for the person actually filling in the data. The table looks like this (proxy example): <pre><code>------------------------------ | FRUITS | VEGGIES | ------------------------------ | Banana | Potato | ------------------------------ | Cherry | Pumpkin | ------------------------------ | Orange | Okra | ------------------------------ </code></pre> Currently, the table is done in standard HTML and I'm using CSS and jQuery to give it specific colours and 'zebra'-striping, respectively. The alphabetical sorting has been done manually. However, with the code set in place the person I'm handing it over to does not want to edit the HTML. She'd rather edit some text file where she can write/edit (this was just a suggestion from a friend): <pre><code>{Banana: Fruit, Potato: Veggies, Okra: Veggies... } </code></pre> The Javascript should then pick up this source file, generate a table where the individual columns are automatically sorted alphabetically and then zebra-striped using the CSS layout. Questions <ol> <li>I've got the jQuery plug-in. What else would I need to actually generate the tables? </li> <li>Would you recommend using the above dictionary structure for the source file or perhaps a CSV file?</li> <li>For the sake of argument, happens when I face the scenario of <code>{Tomato: Fruit, Tomato: Veggies...}</code>. Is there a workaround for this case?</li> </ol> This may seem like overkill, but it's something I need to get done.
Tags
<jquery><html><css><table>
Title
Generating autosorted HTML tables from text file?
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USCommunity
UserOwnerUserId
1. USPizzAzzra
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. PO
 singulars
 PostTypePostTypeId
 PTAnswer
2. PO
 singulars
 PostTypePostTypeId
 PTAnswer
3. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 POGenerating autosorted HTML tables from text file?
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
2. VO
 singulars
 PostPostId
 POGenerating autosorted HTML tables from text file?
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId

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.