Replace value of all refids in collection with the normalized value

ReplaceRefid.xq

xquery version "3.0";
 
declare namespace vra="http://www.vraweb.org/vracore4.htm";
 
let $records := fn:collection("1941")

for $refid in $records//@refid 

return 

replace value of node $refid with fn:normalize-space($refid)

The above code replaced all @refid with normalized version. This updated all the files in the db. I then exported the db to disk using the GUI (Export Data (BaseX: http://docs.basex.org/wiki/Databases#Export_Data)

Here's the documentation on the replace expression: http://docs.basex.org/wiki/XQuery_Update#replace