Ok - I found a way of doing it - avoiding the "too many"
qoutationmarks.
In excel (Calc actually) I wrote this in a cell: ="<<tiddler WikifyK
with:'"&CellX&"'>>"
Where CellX represents a TiddlerName. I copied the cell to fetch all
cells(Tiddlernames) in the row.
In my TW I made a tiddler called WikifyK with this:
<<wikify %0 "fieldn...@$1">>
Then I copied my Calc-sheet into this wonderfull script which
translates excel into a TWtable: <html><p align="center"><textarea
id="xclToTw" rows="10" cols="60"></textarea><br><button
onclick="(function(){var ta=document.getElementById('xclToTw');
displayMessage('original: ' + ta.value); ta.value=ta.value.replace(/^|
$|\t/gm, '|');})();" > Translate</button></p></html>
This worked because I could exchange " for ' and have some of the " in
the WikifyK-tiddler instead of having it in the Claclsheet...
YS Måns Mårtensson
On 30 Aug., 20:35, Måns <[email protected]> wrote:
> This is pretty anoying - why excel is using the same quotationmarks to
> transclude cells - therefore I can't use it :-(
>
> I may have to make some "circular fetching" to make it work??!!
>
> I want the values third column (of a table) to go into this macro :
> <<wikify "[[%0]]" "fieldn...@tiddler Name"\>\>
> Where third row = Tiddler name
> The macros output should show in the fourth column...
> I don't know if this makes sense to you? ...
>
> I have a list which need to be sorted by a filedvalue - which doesn't
> appear on the list - but exists in the tiddlers that are already
> present in the TW ... Thats my problem...
>
> I will try to make excel render one more layer of cells to get the
> right expression - but I doubt that it will come out right...
>
> YS Måns Mårtensson
>
> On 30 Aug., 20:22, Måns <[email protected]> wrote:
>
>
>
> > Hey - I found out by trial and error:
> > I just had to input a lot of quotes everywhere
> > This worked:
> > |<<wikify "[[%0]]" "fieldn...@tiddler Name"\>\>|
>
> > YS Måns Mårtensson
>
> > On 30 Aug., 19:56, Måns <[email protected]> wrote:
>
> > > Hi TwWizards
>
> > > I'm having trouble trying to wikify a field from another (specified)
> > > tiddler in a table.
>
> > > I have tried like this:
> > > 1) |<<wikify [[%0]] fieldname@"Tiddler Name"\>\>|
> > > 1) |<<wikify [[%0]] fieldn...@[[tiddler Name]]\>\>|
> > > 1) |<<wikify [[%0]] fieldn...@[tiddler Name]\>\>|
> > > 1) |<<wikify [[%0]] fieldn...@{{tiddler Name}}\>\>|
>
> > > No output of the fieldvalue from the Tiddler Name tiddler....
>
> > > Do I need some store.get ... thing?
>
> > > Please help me if you can...
>
> > > YS Måns Mårtensson
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"TiddlyWiki" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/tiddlywiki?hl=en
-~----------~----~----~----~------~----~------~--~---
