|
I tried to make a column based on the title, so it would extract the number in series from it, but I can't seem to make it work.
I used this template: {title:[0-9][0-9][0-9][0-9]}
thinking this would return only the number.
Would love to check if the title starts with 'Perry Rhodan' and returns the number automatically.
This way I can use another automatic column with only the first three characters etc.
so I would have these columns:
NumberInSeries1 (containing: 0001, 0002,.. 0100, 0101, etc.) (complete)
NumberInSeries2 (containing: 000, 001, etc.) (tenths)
NumberInSeries3 (containing: 00, 01, etc.) (hundreds)
NumberInSeries4 (containing: 0, 1, etc.) (thousands)
and the template would be something like:
{#NumberInSeries4}000-{#NumberInSeries4}999/{#NumberInSeries3}00-{#NumberInSeries3}99/{#NumberInSeries2}0-{#NumberInSeries2}9/{title}
|