Thanks for the kind words Joshua and for the wonderful plugin and not to forget the tips you have just provided.
As I am the only user for this and I dont mind those settings appearing on the table infact I quite like them. That said someone else might not want to show those and so if I can I will try adding that option. Once again thanks for the jasonmangler plugin - I absolutely love it. On Sat, 1 Aug 2020, 00:02 Joshua Fontany, <joshua.font...@gmail.com> wrote: > Well done! > > Each transclusion of an 'application/csv' tiddler gets its own UNIQUE > state tiddler (all of the options that you can under the first > double-chevron). > This means that you can set each transclusion of a CSV to have its own > "lines per page", "preview or show all" etc. > > IF you want to, you wan wrap the transclusion in a classed Div, like so: > > ``` > <div class="hide-csv-controls"> > {{CSVTIDDLERS/DATA12345}} > </div> > ``` > > Then, by adding and removing the tag `$:/tags/Stylsheet` from a tiddler > with the following text: > ``` > > .hide-csv-controls .tc-csv-options { display: none; } > > .hide-csv-controls .tc-csv-controls { display: none; } > ``` > You can hide the controls on those transclusions (thus not bothering the > reader with things they don't need to see). > > OR split that CSS up into two tiddlers and just hide the Options (keeping > the page controls visible). OR change the class name so you can customize > what is shown or hidden. > > Best, > Joshua Fontany > > On Wednesday, July 29, 2020 at 9:39:52 AM UTC-7 mr.anki...@gmail.com > wrote: > >> Hi Stephen, >> >> First thanks for creating the ever so helpful tool. It is very useful >> indeed. >> >> I was however hell bent on making a button that makes use of the >> "jsonmangler" plugin and I did actually manage to create one this >> afternoon. It's nowhere near as polished as what you have created but it >> works. >> >> In case anyone is interest, I have included the 4 tld files here that can >> simply be loaded on to the demo site for jsonmangler >> <https://joshuafontany.github.io/TW5-JsonMangler/> and then to test >> follow these steps: >> >> 1. Create a new tiddler >> 2. Copy some excel data >> 3. Paste data in new tiddler >> 4. Select the pasted data >> 5. Click on spiral button that appears on the editor buttons. >> 6. Give a name to this table >> 7. Save the tiddler to see the table created. >> >> above steps in pictures: >> [image: exceltbl_20200729-173233.png] >> [image: exceltbl_20200729-173326.png] >> [image: exceltbl_20200729-173519.png] >> [image: exceltbl_20200729-173723.png] >> >> To use it on a local wiki ofcourse one will have to install >> jsonmangler plugin. It however does not beat the lightweight simplicity of >> http://skplugins.tiddlyspot.com/#TableHelper >> <http://skplugins.tiddlyspot.com/#TableHelper> >> >> Thanks a lot for all the help guys. You are all so very kind. :) >> >> >> On Wed, 29 Jul 2020 at 16:01, 'Stephen Kimmel' via TiddlyWiki < >> tiddl...@googlegroups.com> wrote: >> >>> Ankit, >>> >>> When I first developed Tablehelper >>> http://skplugins.tiddlyspot.com/#TableHelper (which predated the XLSX >>> and the regex abilities in TW) I was copying a selected area in an Excel >>> file and pasting it into a tiddler. That data came across as lines with >>> tabs separating the individual cells. What I wanted a TW table and not just >>> something that looked like a table in TW. I later added the ability to >>> convert CSV files which are comma separated cells rather than tab separated >>> cells so I added that capability to my routine. As Eric points out, though, >>> some cells contain commas and other things that can trip up simple regex >>> statements. I ultimately decided that the result wasn't going to be >>> perfect, just easier to finish converting manually. So I added the option >>> to do only tab separated fields which it sounds like what you need. >>> >>> One point to remember, if you are altering a javascript routine, you >>> have to save and refresh the wiki for the change to take effect. >>> >>> Stephen >>> >>> On Wednesday, July 29, 2020 at 2:41:32 AM UTC-5, Ankit Mittal wrote: >>>> >>>> Thanks chaps, for this discussion... helps me understand a few things. >>>> >>>> Although I still dont understand that when i change the comma in the >>>> underlying javascript of the parser why it does not honor the change... >>>> >>>> For my problem of excel workflow, what i need is just the simple >>>> requirement to parse data that is tab separated rather than comma >>>> separated. The work done by Joshua already does the heavy lifting so i am >>>> going to try and create a editor button that opens a modal asking for user >>>> input and then create a tiddler of type application/csv using that user >>>> input and transclude it on current tiddler... something like excise but >>>> with ability to provide application type can do that too... just not sure >>>> if i am setting a goal too high. >>>> >>>> Would either of you gentleman kindly point me to the code behind excise >>>> button please? >>>> >>>> Regards, >>>> Ankit >>>> >>>> >>>> -- >>> You received this message because you are subscribed to the Google >>> Groups "TiddlyWiki" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to tiddlywiki+...@googlegroups.com. >>> >> To view this discussion on the web visit >>> https://groups.google.com/d/msgid/tiddlywiki/4874fef6-a93d-4a93-80b0-31c1ea38ebf7o%40googlegroups.com >>> <https://groups.google.com/d/msgid/tiddlywiki/4874fef6-a93d-4a93-80b0-31c1ea38ebf7o%40googlegroups.com?utm_medium=email&utm_source=footer> >>> . >>> >> -- > You received this message because you are subscribed to the Google Groups > "TiddlyWiki" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to tiddlywiki+unsubscr...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/tiddlywiki/83d0b67c-437a-428f-8a66-f6ceb49290afn%40googlegroups.com > <https://groups.google.com/d/msgid/tiddlywiki/83d0b67c-437a-428f-8a66-f6ceb49290afn%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- You received this message because you are subscribed to the Google Groups "TiddlyWiki" group. To unsubscribe from this group and stop receiving emails from it, send an email to tiddlywiki+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/tiddlywiki/CAAgqyEUHx77p5QnNr3Sv376fhuxxZ_UkfnyXLk1P1BC1tHuPjQ%40mail.gmail.com.