Hi Tony,
Thanks for the suggestion, but my skills as they are mean I don't know how
to apply this for all the records.
The notepad option works really well as I can just copy the date column
from the spreadsheet (containing 3.5 thousand rows) and paste into Notepad
++ and apply the regex to the whole lot and then copy it back into the
spreadsheet.
That means I can also have one column for the tiddler title eg. 07/06/20
and another to include the system date.
However, I hadn't twigged that I still need the extra time zeros for the
date to be recognised as a system date.
So, just to clarify, does 2020-06-07120000000 (i.e. '12' and 7 zeros)
qualify as the system date?
In which case I can just add this in the regex.
Regards
Jon
On Tuesday, 9 June 2020 00:56:00 UTC+1, TonyM wrote:
>
> Jon,
>
> You can apply regex in tiddlywiki, so perhaps you can use your notpad++
> method?
>
> I will suggest once again (forcefully) if you want a global solution, then
> convert dates to the system date format then you can use $view date to
> display any format, including the relative date.
>
> If your input date is 20/06/07 and its the title of a tiddler, try this on
> tiddlywiki.com
>
> \define cc-date(date) 20$date$
> \define date-yy-mm-dd(date) <$text text={{{
> [[20$date$]split[/]join[]addsuffix[120000000]]
> }}}/>
>
>
> :redate <<cc-date "20/06/07">> quick reformat for appearance
> :<$macrocall $name=cc-date date={{!!title}}/> using title/field or
> variable
> :<<date-yy-mm-dd "20/06/07">> reformat to serial date, also set to 12 noon
>
>
> <$wikify name=journal-date text="""<$macrocall $name=date-yy-mm-dd
> date={{!!title}}/>""" output=text>
> <$button>
> <$action-setfield $field=journal-date $value=<<journal-date>>/>
> set journal date
> </$button>
> </$wikify>
>
>
> journal-date=<$view field=journal-date format=date template="YYYY/0MM/0DD"/>
> or <$view field=journal-date format=relativedate/>
>
> Regards
> Tony
>
> On Tuesday, June 9, 2020 at 2:50:55 AM UTC+10, Jon wrote:
>>
>> Hi Hubert,
>>
>> Thanks for this, which I'll be able to use down the line but at the
>> moment, I wouldn't know how to apply this globally.
>>
>> However, I've managed to find a solution using a text editor like Notepad
>> ++. Instructions below for anyone else looking for this.
>>
>> So, to convert 18/09/10 to 2018-09-10
>>
>> Select 'Regular expression' in Search Mode
>>
>> 'Find what' ([0-9]{2})/+([0-9]{2})/+([0-9]{2})
>>
>> 'Replace with' 20\1-\2-\3
>>
>> there's a bit more info. here
>> <https://stackoverflow.com/questions/4331138/find-and-replace-with-reordered-date-format-in-notepad>
>>
>> Thanks
>> Jon
>>
>> On Monday, 8 June 2020 16:22:00 UTC+1, Hubert wrote:
>>>
>>> Hi Jon,
>>>
>>> You can use this ugly macro below to "convert" any string like this:
>>> "20/06/07" into this: "2020/06/07", assuming that the earliest year in your
>>> range is the year 2000.
>>>
>>> Paste this macro definition in a new tiddler:
>>>
>>> \define UpdateDate(date)
>>> <$vars
>>> y={{{ [<__date__>split[/]nth[1]add[2000]] }}}
>>> m={{{ [<__date__>split[/]nth[2]] }}}
>>> d={{{ [<__date__>split[/]nth[3]] }}}>
>>> <<y>>/<<m>>/<<d>>
>>> </$vars>
>>> \end
>>>
>>> And then below that, put your input dates in the macro like this:
>>>
>>> <<UpdateDate 20/06/07>>
>>>
>>> When you save the tiddler the output will be rendered to this: 2020/06/07
>>>
>>> You can wrap this macro in a filter to change all dates in one go and
>>> then simply copy/paste the output.
>>>
>>> The whole operation would probably be quicker and simpler using a text
>>> editor as these are just strings, not to mention that the above macro can
>>> probably be simplified to a one-liner. Anyway, just something quick.
>>>
>>> Regards,
>>> Hubert
>>>
>>
--
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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/tiddlywiki/fb0ef4f8-39c2-40c2-9294-23374a125b25o%40googlegroups.com.
