It is similar as the code I sent before:
<results>{
for $nodes in $data//Field[@Code="DESC"]//Value
return <result>
{fn:string-join(
for $node in $nodes/node()
let $value := string($node)
return if(fn:name($node) eq "S")
then if($value eq "t") then "1"
else if($value eq "ƒ") then "2"
else if($value eq "„") then "3"
else $value
else $value, "")
}</result>}
</results>
>
<results>
<result>00 ab1– 2145/200CHF3195/300CHF</result>
<result>25 rm1– 2145/200CHF3195/300CHF</result>
</results>
You can define a private function to replace the if/else if/else and
use typeswitch to check the element name.
John
On Mon, Sep 23, 2013 at 2:07 AM, sini narayanan <[email protected]>wrote:
> Hi John,
>
> For each of the <Field Code="DESC"> node, i need to generate an result
> node to store all text values under <Value> node.
>
> Sample source xml:
>
> <fields>
> <Field Code="DESC">
> <List>
> <Value lang="fr" Code="DESC">
> <B>00 ab</B>
> <DI/>
> <S>t</S>
> <SP/>– <S>ƒ</S>145/200<DI/>CHF<SP/>
> <S>„</S>195/300<DI/>CHF</Value>
> </List>
> </Field>
> <Field Code="DESC">
> <List>
> <Value lang="en" Code="DESC">
> <B>25 rm</B>
> <DI/>
> <S>t</S>
> <SP/>– <S>ƒ</S>145/200<DI/>CHF<SP/>
> <S>„</S>195/300<DI/>CHF</Value>
> </List>
> </Field>
> </fields>
>
> Expected output:
>
> <results>
> for $nodes in $data//fields/Field[Code="DESC"]
> return
> <result>{$nodes/string()}</result> (:This would join all the node values
> under DESC and then return the result :)
> </results>
>
> Here I need to apply condition only for <S> nodes. whenever it is node
> <S>, instead of the value t/ƒ/„ i need to output the value as 1/2/3
>
> If the result is something like
> 00 abt– ƒ145/200CHF„195/300CHF
> I need it as
> 00 ab1– 2145/200CHF3195/300CHF (:t/ƒ/„ values changed to 1/2/3
> respectively:)
>
> How do I do this?
>
> Thanks
>
>
> On Wed, Sep 4, 2013 at 7:19 PM, John Zhong <[email protected]> wrote:
>
>> for $field in $doc//field
>> return <output>{fn:string-join(($field/(A,B), if($field/C eq 'z') then
>> '012' else if($field/C eq 'x') then '098' else $field/C))}</output>
>>
>> John
>>
>>
>> On Wed, Sep 4, 2013 at 9:33 AM, sini narayanan
>> <[email protected]>wrote:
>>
>>> Hi All,
>>>
>>> I have an xml file with the following structure
>>> <fields>
>>> <field>
>>> <A>abc</A>
>>> <B>def</B>
>>> <C>z</C>
>>> </field>
>>> <field>
>>> <A>abc</A>
>>> <B>def</B>
>>> <C>x</C>
>>> </field>
>>> </fields>
>>>
>>> For each of the field nodes, I need to generate the output as the node
>>> value of all the child nodes under a field node.
>>> ie: <output>abcdefz</output>
>>> <output>abcdefx</output>
>>>
>>> This I can simply get it using the string() value.
>>>
>>> let $doc := doc("/Test/file.xml")
>>> for $i in $doc//fields/field
>>> return
>>> <output>{$i/string()}</output>
>>>
>>> But here I need an extra processing to be done only for node <C>. ie.
>>> based on the node value of C node, i need to perform a translation.
>>> If C/text() eq z then 012 should be the output and if C/text() eq x then
>>> 098 should be the output.
>>>
>>> So the final output expected is
>>> <output>abcdef012</output>
>>> <output>abcdef098</output>
>>>
>>> How do I achieve this easily in the code that I mentioned earlier.
>>>
>>> Thanks,
>>> Sini
>>>
>>> _______________________________________________
>>> General mailing list
>>> [email protected]
>>> http://developer.marklogic.com/mailman/listinfo/general
>>>
>>>
>>
>> _______________________________________________
>> General mailing list
>> [email protected]
>> http://developer.marklogic.com/mailman/listinfo/general
>>
>>
>
> _______________________________________________
> General mailing list
> [email protected]
> http://developer.marklogic.com/mailman/listinfo/general
>
>
_______________________________________________
General mailing list
[email protected]
http://developer.marklogic.com/mailman/listinfo/general
