[EP-tech] Antwort: Re: search for 2-character-string

martin.braendle at id.uzh.ch martin.braendle at id.uzh.ch
Mon Oct 5 07:50:51 BST 2015

In Advanced Search, allowed are % (matching exactly 1 character) or *
(matching 0 or any number of characters). Wildcards are only trailing.

So something like na* should match those words that start with Na.

See also http://www.zora.uzh.ch/help/

What is not clear to me whether your chemical systems describe general
compositions (Sodiumtoluenesulfonate with an arbitray amount of crystal
water, e.g. CAS RN 1240939-71-2, Sodium(1+), aqua-,
4-methylbenzenesulfonate (1:1), C7 H7 O3 S . H2 O . Na, CAS RN 28573-41-3,
Benzenesulfonic acid, 4-methyl-, sodium salt, hydrate (2:2:1), C7 H8 O3 S .
1/2 H2 O . Na ,  and CAS RN 337511-98-5,  C7 H8 O3 S . x H2 O . Na,
Benzenesulfonic acid, 4-methyl-, sodium salt, hydrate (1:1:?)) or just the
exact mono-hydrate system: CAS RN 1240939-71-2.

If the latter, as a chemical information specialist, I strongly suggest to
use either standardized English IUPAC names or CAS names for your chemical
systems and in addition use either CAS Registry Numbers or InChI.

Best regards,


Dr. Martin Brändle
Zentrale Informatik
Universität Zürich
Stampfenbachstr. 73
CH-8006 Zürich

Von:	Thomas Lauke <th.lauke at arcor.de>
An:	eprints-tech at ecs.soton.ac.uk
Datum:	02/10/2015 18:20
Betreff:	[EP-tech] Re: search for 2-character-string
Gesendet von:	eprints-tech-bounces at ecs.soton.ac.uk

> Could you give a little more context?
we like to realize something similar to

mysql> select * from eprint_system where system like '%na%';
| eprintid | pos | system                  |
|     6550 |   0 | binary oceanic          |
|     8468 |   7 | Na-p-Toluensulfonat-H2O |
|     8468 |   6 | Li-p-Toluensulfonat-H2O |

but want to search for 'na-%' likewise ...

Currently just a search for the complete system string, like
'Item Status matches any of "User Workarea", "Under Review", "Live Archive"
AND System is "binary oceanic"',
is successful ...

Thanks in advance
*** Options: http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
*** Archive: http://www.eprints.org/tech.php/
*** EPrints community wiki: http://wiki.eprints.org/
*** EPrints developers Forum: http://forum.eprints.org/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.ecs.soton.ac.uk/pipermail/eprints-tech/attachments/20151005/c6f25bf1/attachment.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: graycol.gif
Type: image/gif
Size: 105 bytes
Desc: not available
Url : http://mailman.ecs.soton.ac.uk/pipermail/eprints-tech/attachments/20151005/c6f25bf1/attachment.gif 

More information about the Eprints-tech mailing list