Splitting a sequence and incrementing using Xquery

Question

I have an xml like below , am trying to convert the xml in to csv

<module>
    <content>
        <catalouge SC="25" item="200">
            <Number id="250" RefIds="xyz20000">
                <Character condValue="PRE">
                    <count Number="1" Name="Sree" changeMark="1">FOR A/C 0013, 0047, 0063</count>
                </Character>
                <Character condValue="EMB">
                    <count Number="154" Name="Sree" changeMark="1">FOR A/C 0005-0010, 0021, 0025, 0033</count>
                </Character>
            </Number>
        </catalouge>
        <catalouge SC="180" item="200" >
            <Number id="780" RefIds="xyz20000">
                <Character condValue="EMB">
                    <count Number="1" Name="AB">FOR A/C 0006-0011</count>
                </Character>
                <Character condValue="EMB">
                    <count Number="154" Name="Sree" changeMark="1">FOR A/C 0013</count>
                </Character>
            </Number>
        </catalouge>
        <catalouge SC="567" item="240">
            <Number id="666" Value="123" RefIds="xyz20000">
                <Character condValue="EMB">
                    <count Number="2" Name="SB">FOR A/C 0008-0013</count>
                </Character>
                <Character condValue="PRE">
                    <count Number="1" Name="cherry" changeMark="1">FOR A/C 0018, 0047, 0063</count>
                </Character>
            </Number>
        </catalouge>
        <catalouge SC="8" item="280">
            <Number id="1994" Value="1234" RefIds="xyz20000" >
                <Character condValue="POST">
                    <count Number="3" Name="Sree" changeMark="1">FOR A/C 0006, 0047, 0063, 0090, 0143, 0172</count>
                </Character>
            </Number>
        </catalouge>
    </content>
</module>

My xquery is as below

for  $p in doc("dar.xml")//module/content/catalouge
            let $SC := $p/string(@SC)
            let $item := $p/string(@item)
            let $isns := $p/Number
            for $isn in $isns
              let $id := $isn/string(@id)
              let $Ref := $isn/string(@RefIds)              
              let $chr := (for $x in $isn return string-join($x//Character//@condValue,", "))
              let $chr_status := contains($chr, 'EMB')
              **let $count :=  $isn/Character/data(count)
              let $count_status :=  contains($chr, '0006')**
              let $Num :=  $isn/Character/count/string(@Number)
              let $sep :=";"
return (if($chr_status and $count_status) 
    then ()
  else(concat($SC,$sep,$item,$sep,$id,$sep,$Ref)) 
)

I'm performing an and operation here if both status are true it should print nothing if it is false it should print some value. My Output should as below:

567;240;666;xyz20000
8;280;1994;xyz20000

But here my issue is, the data which is present in count tag , has a sequence of values , How can I increment the range tokenize those and search for 0006 which returns a boolean value

<count Number="154" Name="Sree" changeMark="1">FOR A/C 0005-0012, 0021, 0025, 0033</count>

FOR A/C 0005-0012, 0021, 0025, 0033 which actually mean 0005 to 0012--> I have sequence 0005,0006,0007,0008,0009,0010,0011,0012,0021, 0025, 0033

Any ideas would be greatly appreciated, Thanks!

Answer 1

This seems to be similar to your previous question, you can use tokenize and the to operator after removing the FOR A/C prefix:

//count 
! 
(. 
|| ': ' 
|| (((
     substring-after(., 'FOR A/C ') ! 
     tokenize(., ', ') ! 
     (let $tokens := tokenize(., '-')!xs:integer(.) 
      return 
          (
              if ($tokens[2]) 
              then ($tokens[1] to $tokens[2]) 
              else $tokens[1])
          ) 
    ! format-integer(., '0001')) = '0006')))

https://xqueryfiddle.liberty-development.net/94hwpi2/2 gives

FOR A/C 0013, 0047, 0063: false
FOR A/C 0005-0010, 0021, 0025, 0033: true
FOR A/C 0006-0011: true
FOR A/C 0013: false
FOR A/C 0008-0013: false
FOR A/C 0018, 0047, 0063: false
FOR A/C 0006, 0047, 0063, 0090, 0143, 0172: true