MobileRead Forums - View Single Post - Help with RegEx to parse title with colon

eschwartz · 02-16-2016, 02:13 AM

This will get you the first portion (before the ":")

Code:

program:

re(
    field('title'),
    ':.*',
    ''
)

Alternatively, "cheat" by using list_item() and pretending it is a ":"-separated list:

Code:

program:

list_item(
    field('title'),
    0,
    ':'
)

...

Personally, I think this is exactly what custom columns named "#subtitle" are for, but you are the boss...

02-16-2016, 02:13 AM	#4
eschwartz Ex-Helpdesk Junkie Posts: 19,421 Karma: 85400180 Join Date: Nov 2012 Location: The Beaten Path, USA, Roundworld, This Side of Infinity Device: Kindle Touch fw5.3.7 (Wifi only)	This will get you the first portion (before the ":") Code: program: re( field('title'), ':.*', '' ) Alternatively, "cheat" by using list_item() and pretending it is a ":"-separated list: Code: program: list_item( field('title'), 0, ':' ) ... Personally, I think this is exactly what custom columns named "#subtitle" are for, but you are the boss...