View Single Post
Old 06-15-2014, 08:25 PM   #4
eschwartz
Ex-Helpdesk Junkie
eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.
 
eschwartz's Avatar
 
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)
Quote:
Originally Posted by Sabardeyn View Post
I cannot think of the exact regex you would need. Roughly, it would probably be the identifier's name, a colon and then "all characters, greedy, until the next whitespace/word end". So something like... ID:+.? Or is it ID:.+? Hmm.. think I'm missing the word boundary. Anyway, I'm not sure if the expression is written correctly. But hopefully you've got the idea. I imagine that the colon might need to be escaped.
When S&Ring the identifiers field, each identifier acts as a self-contained unit. So the regex would be ".*", and replaced with a null value.

Quote:
I would definitely suggest trying this on a sample database. Just to make sure that it doesn't harm anything else. Maybe create a new library and then copy various sample books into it, run the regex and see what happens.
I second the idea of testing this out first, always a good idea when doing Bulk S&R -- with a powerful tool like that, you have room to mess up quite badly.

Last edited by eschwartz; 06-16-2014 at 11:13 AM. Reason: typo
eschwartz is offline   Reply With Quote