Skip to content

Instantly share code, notes, and snippets.

View sterkenburgsara-zz's full-sized avatar

Sara Sterkenburg sterkenburgsara-zz

  • Vanderbilt University
  • Nashville, TN
View GitHub Profile
@CliffordAnderson
CliffordAnderson / build-ead.xqy
Last active August 29, 2015 14:22
XQuery to clean up data from an Excel-generated webpage & generate an EAD document
xquery version "3.1";
(: Extracts data from Excel website and packages information as JSON map :)
declare function local:get-data($url as xs:string) as map(*)* {
let $request :=html:parse(fetch:text($url,'windows-1254'), map { 'encoding': 'UTF-8' })//table/tr
for $item in $request[position() = 2 to last()-1]
let $title := fn:normalize-space(fn:string-join($item/td[1]/a/text()))
let $category := $item/td[2]/text()
let $translation := $item/td[3]/text()
let $image := $item/td[4]/text()
@baskaufs
baskaufs / gist:5fd10712361e27b7c2c4
Created April 17, 2015 21:30
finding document URIs for attributes with leading or trailing whitespace
xquery version "3.0";
declare namespace vra="http://www.vraweb.org/vracore4.htm";
for $name in fn:collection("Metadata")//vra:agent
(:where substring($name/vra:name/text(),1,5)="Burri":)
where normalize-space($name/vra:name/@refid/data()) != $name/vra:name/@refid/data()
return $name/vra:name/text()||"
"||base-uri($name/vra:name)||"
"||"
"