MobileRead Forums - View Single Post - Plugboard, template, and custom composite column recipes

culytera · 08-23-2023, 01:49 AM

I have a custom column #date_range that's populated via FanFicFare using the date updated and date published metadata. I have a regex for it in FFF's settings:

Code:

## diff dates     1pmonth    2pday        3pyear   4umonth    5uday        6uyear
 dateRange_LIST=>([^\s]+)\s+(\d{1,2})\,\s+(\d{4})\,\s([^\s]+)\s+(\d{1,2})\,\s+(\d{4})=>\1 \2, \3-\4 \5, \6
## same year      1          2            3        4          5
 dateRange_LIST=>([^\s]+)\s+(\d{1,2})\,\s+(\d{4})-([^\s]+)\s+(\d{1,2})\,\s+\3=>\1 \2-\4 \5, \3
## same month     1          2              3            4
 dateRange_LIST=>([^\s]+)\s+(\d{1,2})-\1\s+(\d{1,2})\,\s+(\d{4})=>\1 \2-\3, \4

Example results:

Different dates: January 1, 2022-April 1, 2023
Same year: May 20-August 23, 2023
Same month: August 10-15, 2023
Same day: August 23, 2023

And so I was wondering if this is also possible to do with a column built from other columns + templates since I have published date and updated date columns.

08-23-2023, 01:49 AM	#955
culytera Zealot Posts: 125 Karma: 295674 Join Date: Jul 2021 Device: iPhone	I have a custom column #date_range that's populated via FanFicFare using the date updated and date published metadata. I have a regex for it in FFF's settings: Code: ## diff dates 1pmonth 2pday 3pyear 4umonth 5uday 6uyear dateRange_LIST=>([^\s]+)\s+(\d{1,2})\,\s+(\d{4})\,\s([^\s]+)\s+(\d{1,2})\,\s+(\d{4})=>\1 \2, \3-\4 \5, \6 ## same year 1 2 3 4 5 dateRange_LIST=>([^\s]+)\s+(\d{1,2})\,\s+(\d{4})-([^\s]+)\s+(\d{1,2})\,\s+\3=>\1 \2-\4 \5, \3 ## same month 1 2 3 4 dateRange_LIST=>([^\s]+)\s+(\d{1,2})-\1\s+(\d{1,2})\,\s+(\d{4})=>\1 \2-\3, \4 Example results: Different dates: January 1, 2022-April 1, 2023 Same year: May 20-August 23, 2023 Same month: August 10-15, 2023 Same day: August 23, 2023 And so I was wondering if this is also possible to do with a column built from other columns + templates since I have published date and updated date columns.