EPrints Technical Mailing List Archive

Message: #04842

< Previous (by date) | Next (by date) > | < Previous (in thread) | Next (in thread) > | Messages - Most Recent First | Threads - Most Recent First

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

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,

Martin

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

Inactive hide details for Thomas Lauke ---02/10/2015 18:20:10---> Could you give a little more context? we like to realize someThomas Lauke ---02/10/2015 18:20:10---> Could you give a little more context? we like to realize something similar to

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