Custom Column - Split Multi Values

nynaevelan · 10-27-2014, 03:00 AM

Hi:

I need a little help trying to create a custom column based off of a previous custom column which has multi-values. I would like to create the second custom column which would output only the first value of the first custom column. Can someone help me set this up?

chaley · 10-27-2014, 04:14 AM

This should do it after you replace #mytextmult with the name of your multi-valued column

Code:

program: sublist(field('#mytextmult'), 0, 1, ',')

Tanjamuse · 10-27-2014, 04:27 AM

What if I want only the second or third value?

chaley · 10-27-2014, 04:41 AM

Quote:

Originally Posted by Tanjamuse

What if I want only the second or third value?

Change the "0, 1" to select the value(s) you want. Quoting the documentation for sublist:

Quote:

sublist(val, start_index, end_index, separator) – interpret the value as a list of items separated by separator, returning a new list made from the start_index to the end_index item. The first item is number zero. If an index is negative, then it counts from the end of the list. As a special case, an end_index of zero is assumed to be the length of the list. Examples using basic template mode and assuming that the tags column (which is comma-separated) contains “A, B, C”: {tags:sublist(0,1,,)} returns “A”. {tags:sublist(-1,0,,)} returns “C”. {tags:sublist(0,-1,,)} returns “A, B”.

nynaevelan · 10-27-2014, 05:19 AM

Thank you for your quick response and for you answer, once again you have made my database a little bit easier to use.

10-27-2014, 03:00 AM	#1
nynaevelan eBook Junkie Posts: 1,526 Karma: 1464018 Join Date: May 2010 Location: USA Device: Kindle Fire 2020, Kindle PW2	Custom Column - Split Multi Values Hi: I need a little help trying to create a custom column based off of a previous custom column which has multi-values. I would like to create the second custom column which would output only the first value of the first custom column. Can someone help me set this up?

10-27-2014, 04:14 AM	#2
chaley Grand Sorcerer Posts: 12,038 Karma: 7257323 Join Date: Jan 2010 Location: Notts, England Device: Kobo Libra 2	This should do it after you replace #mytextmult with the name of your multi-valued column Code: program: sublist(field('#mytextmult'), 0, 1, ',')

10-27-2014, 04:27 AM	#3
Tanjamuse Wizard Posts: 1,327 Karma: 5306 Join Date: Jan 2014 Device: none	What if I want only the second or third value? Last edited by Tanjamuse; 10-27-2014 at 04:30 AM.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Default Value for Custom Column (fixed set of permitted values)	Andy P	Calibre	1	06-21-2013 04:25 AM
Filling a Custom Column with Auto-Incremented Values	Laurelton	Library Management	4	12-13-2012 03:25 AM
Custom Column with list of permitted values	Eugenie	Library Management	1	01-10-2012 04:57 AM
Boolean custom column values	sengian	Library Management	4	01-05-2012 06:39 PM
Multiple comma separated values in custom column?	silentguy	Library Management	8	04-19-2011 06:10 AM

10-27-2014, 05:19 AM	#5
nynaevelan eBook Junkie Posts: 1,526 Karma: 1464018 Join Date: May 2010 Location: USA Device: Kindle Fire 2020, Kindle PW2	Thank you for your quick response and for you answer, once again you have made my database a little bit easier to use.

Advert

Advert