Hi all,
I'm using the following xquery (after being helped by Christian).
declare variable $in external; declare variable $out external; declare variable $vendor external;
let $options := map { 'header': true() } let $text := file:read-text($in) let $xml := csv:parse($text, $options)
let $result := <csv>{ for $record in $xml//record[contains(VENDORS, $vendor) and not(contains(HOST, "Non external")) and not(empty(HOST))]
return <record>{
$record/(HOST, PATH, ATTACKCOUNT, TIME_STAMP,CK) }</record>
}</csv> return file:write-text($out, csv:serialize($result, $options))
I would like to have one of the returned records encrypted. How do I change that record before saving it? I tried: return <record>{
crypto:encrypt($record/CK, 'symmetric','keykeyke','DES'), $record/(HOST, PATH, ATTACKCOUNT, TIME_STAMP,CK) }</record>
But that doesn't really change the CK field. I can't seem to modify anything in the $record/(HOST, PATH, ATTACKCOUNT, TIME_STAMP,CK).
Any thoughts? Thanks, Noam