MobileRead Forums - View Single Post - Customize the positive and negative number format on an integer column

chaley · 10-12-2020, 07:52 AM

And for more fun, an equivalent but more compact template that uses the stored template:

Code:

program:
	universe = field('#text');
	year = raw_field('#myint');
	first_non_empty(
		test(universe == 'Star Wars', universe_year(year, 'BBY', 'ABY'), ''),
		test(universe == 'Dune', universe_year(year, 'BG', 'AG'), ''),
		'Unknown Universe'
	)

10-12-2020, 07:52 AM	#3
chaley Grand Sorcerer Posts: 12,476 Karma: 8025702 Join Date: Jan 2010 Location: Notts, England Device: Kobo Libra 2	And for more fun, an equivalent but more compact template that uses the stored template: Code: program: universe = field('#text'); year = raw_field('#myint'); first_non_empty( test(universe == 'Star Wars', universe_year(year, 'BBY', 'ABY'), ''), test(universe == 'Dune', universe_year(year, 'BG', 'AG'), ''), 'Unknown Universe' )