MobileRead Forums - View Single Post

BetterRed · 04-30-2017, 05:42 PM

@rellwood - maybe this will work.

Add a custom column of type Column built from other columns with a template that formats the date as year, month and day (e.g. 2017-05-01), then in Bulk MDE Search and Replace append that column to a Tag like custom column. Tag like columns can have multiple values, won't allow duplicates, and will display the values in a sensible order.

I'll leave you to work out the custom column template and the Bulk MDE S&R spec (once you have one that works you can save it for later reuse). IIRC the manual has some examples for dealing with dates in templates, and the Mode parameter in Bulk MDE S&R has an Append option.

BR

04-30-2017, 05:42 PM	#7
BetterRed null operator (he/him) Posts: 21,820 Karma: 30277270 Join Date: Mar 2012 Location: Sydney Australia Device: none	@rellwood - maybe this will work. Add a custom column of type Column built from other columns with a template that formats the date as year, month and day (e.g. 2017-05-01), then in Bulk MDE Search and Replace append that column to a Tag like custom column. Tag like columns can have multiple values, won't allow duplicates, and will display the values in a sensible order. I'll leave you to work out the custom column template and the Bulk MDE S&R spec (once you have one that works you can save it for later reuse). IIRC the manual has some examples for dealing with dates in templates, and the Mode parameter in Bulk MDE S&R has an Append option. BR