XML element case sensitivity
Saturday, 16 June 2012 · 3 messages
DL
David Leigh16 Jun 2012 15:51 #
I've been searching in the BaseX docs online and can't seem to find reference to what I'm seeing. It may be common knowledge in the XML community but I'm not highly skilled in XML.
Here's my issue:
I have XML files that I'm loading into my database where there is inconsistency in the case (capital vs. lower-case) of the tag names (XML elements I think?). For instance, I have a tag named "lyrics" and sometimes in the files (whose source is not necessarily under my control) that will be <lyrics> and sometimes <Lyrics>. It could of course, by someone's error also be <lYrIcS> or any other weird combination. Is there a way, either at database creation or via some option or at query time to say that "lyrics" = "Lyrics" = "LyRics", etc. i.e. to be case insensitive for the XML tag names?
Thanks!
David
<mailto:david at leighweb.com> DavidEmailSigDK
Dirk Kirsten16 Jun 2012 16:46 #
There are functions like lower-case() and upper-case(). So you could do something like this
//*[lower-case(name(.)) = "lyrics"]
However, I guess it could result in a decreased performance. Therefore it might be reasonable to do this in some kind of preprocessing, if it is relevant for your use-case.
cheers,
Dirk
Quoted text · David Leigh · 29 lines
On 06/16/2012 03:51 PM, David Leigh wrote: > I’ve been searching in the BaseX docs online and can’t seem to find > reference to what I’m seeing. It may be common knowledge in the XML > community but I’m not highly skilled in XML. > > Here’s my issue: > > I have XML files that I’m loading into my database where there is > inconsistency in the case (capital vs. lower-case) of the tag names (XML > elements I think?). For instance, I have a tag named “lyrics” and > sometimes in the files (whose source is not necessarily under my > control) that will be <lyrics> and sometimes <Lyrics>. It could of > course, by someone’s error also be <lYrIcS> or any other weird > combination. Is there a way, either at database creation or via some > option or at query time to say that “lyrics” = “Lyrics” = “LyRics”, etc. > i.e. to be case insensitive for the XML tag names? > > Thanks! > > David > > DavidEmailSig <mailto:david at leighweb.com> > > > > _______________________________________________ > BaseX-Talk mailing list > BaseX-Talk at mailman.uni-konstanz.de > https://mailman.uni-konstanz.de/mailman/listinfo/basex-talk
JE
Jens Erat16 Jun 2012 20:01 #
Hi David,
for preprocessing you could use something like
for $i in //*
return rename node $i as lower-case(name($i))to rename all nodes to their lower-case equivalent. If you only want to process lyrics-nodes of all variations, insert Dirk's predicate to
//*.
Sadly the full-text index which offers case insensitivity doesn't include tag names, so you can't use this either.
Kind regards from Lake Constance, Germany,
Jens--
Jens Erat
[phone]: tel:+49-151-56961126
[mail]: mailto:email at jenserat.de
[jabber]: xmpp:jabber at jenserat.de
[web]: http://www.jenserat.de
PGP: 350E D9B6 9ADC 2DED F5F2 8549 CBC2 613C D745 722B
Quoted text · Dirk Kirsten · 45 lines
Am 16.06.2012 um 16:46 schrieb Dirk Kirsten: > There are functions like lower-case() and upper-case(). So you could do something like this > > //*[lower-case(name(.)) = "lyrics"] > > However, I guess it could result in a decreased performance. Therefore it might be reasonable to do this in some kind of preprocessing, if it is relevant for your use-case. > > cheers, > Dirk > > > On 06/16/2012 03:51 PM, David Leigh wrote: >> I’ve been searching in the BaseX docs online and can’t seem to find >> reference to what I’m seeing. It may be common knowledge in the XML >> community but I’m not highly skilled in XML. >> >> Here’s my issue: >> >> I have XML files that I’m loading into my database where there is >> inconsistency in the case (capital vs. lower-case) of the tag names (XML >> elements I think?). For instance, I have a tag named “lyrics” and >> sometimes in the files (whose source is not necessarily under my >> control) that will be <lyrics> and sometimes <Lyrics>. It could of >> course, by someone’s error also be <lYrIcS> or any other weird >> combination. Is there a way, either at database creation or via some >> option or at query time to say that “lyrics” = “Lyrics” = “LyRics”, etc. >> i.e. to be case insensitive for the XML tag names? >> >> Thanks! >> >> David >> >> DavidEmailSig <mailto:david at leighweb.com> >> >> >> >> _______________________________________________ >> BaseX-Talk mailing list >> BaseX-Talk at mailman.uni-konstanz.de >> https://mailman.uni-konstanz.de/mailman/listinfo/basex-talk > > _______________________________________________ > BaseX-Talk mailing list > BaseX-Talk at mailman.uni-konstanz.de > https://mailman.uni-konstanz.de/mailman/listinfo/basex-talk
Written for BaseX 7.2. BaseX may have changed since: please check the current documentation.
⚡Generated with XQuery