Question. I have this composite column, with sort/search by text:
Code:
program:
input = $#kobobookmark;
a = re(input, '.*\/file(\d+).*', '\1');
fan = $#fanficcat;
status = $#fanficstatus;
ccount = $$#chaptercount;
if
fan
&&
status !='Anthology'
&&
$#currentlyreading
&&
substr(input, 0, 10) == 'OEBPS/file'
then
strcat(format_number(subtract(a, 1), '{0:,d}'), '/',ccount)
elif
status ='Oneshot'
then
ccount
elif
ccount >#1
then
ccount
fi
On a non-fanfiction book with an undefined ccount this displays as "None." If I switch to non-raw field it becomes blank instead.
I don't mind it here, but why does raw field result in "none" instead of blank?
Actually I just realized I could probably remove the second elif statement and combine it with the third with a != compare op...