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

ownedbycats · 02-21-2022, 10:33 AM

Something like this should work.

Code:

program:
## obviously replace $#yournum with your column
	if 
			$#yournum>=#10000000
		&& 
			$#yournum<=#10999999
	then
## using 'round' to fix the float/decimal output I got in my test
		round(subtract($#yournum, 100000000))

	else
		$#yournum

	fi

You'll want the "else $#yournum" or it will give you a blank for those instances.

02-21-2022, 10:33 AM	#927
ownedbycats Custom User Title Posts: 11,110 Karma: 77213681 Join Date: Oct 2018 Location: Canada Device: Kobo Libra H2O, formerly Aura HD	Something like this should work. Code: program: ## obviously replace $#yournum with your column if $#yournum>=#10000000 && $#yournum<=#10999999 then ## using 'round' to fix the float/decimal output I got in my test round(subtract($#yournum, 100000000)) else $#yournum fi You'll want the "else $#yournum" or it will give you a blank for those instances. Last edited by ownedbycats; 02-21-2022 at 10:35 AM.