View Single Post
Old 10-21-2010, 09:21 AM   #11
Arco Witter
Member
Arco Witter began at the beginning.
 
Posts: 21
Karma: 10
Join Date: Jan 2010
Device: iRex iLiad
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}
Arco Witter is offline   Reply With Quote