Thank you, and that does work for text based columns. I had seen a similar solution in post:
https://www.mobileread.com/forums/sho...d.php?t=265061
I'm trying to make it more automated by using the
'column built from other columns' feature. What I was hoping for was to input a template into the make column from other columns for #maintitle(no colon) and #subtitle. Then have Calibre automatically save the book based on a template using the truncated #maintitle column as part of the folder name & file name.
I tried several templates for the custom column but don't know what I'm doing. such as
#maintitle =
contains(field('title')([^:]*))
#subtitle =
contains(field('title')([^:]*)re(field('title')
somewhere in these forums someone said to split the title into two columns, which we have achieved. But that means I have to manually run that search & replace, and then resave the books to the library based on another template and action.
Thank you for your assistance