Qlik Brasil
Boa noite.
tenho uma lista de arquivos xml e preciso:
ler o startTime da tag Phrase se ele for >0 (maior que zero). Porém, se ele for = 0, tenho que ler o primeiro valor de length <>0 dentro da tag <Token> de cada arquivo.
Ex: do Arquivo 1 preciso capturar apenas o "0.385", pois, <Phrase startTime="0.000" endTime="5.605">
já do Arquivo 2, preciso capturar "2.645" da tag <Phrase>
Arquivo1:
<?xml version="1.0"?>
<Trans scribe="auto" version="0" version_date="">
<Speakers>
<Speaker id="spk1" name="looser [Telefono] 0" check="no" type="dooo" dialect="native" accent="" scope="local"/>
<Speaker id="spk2" name="looser [Telefono] 1" check="no" type="dooo" dialect="native" accent="" scope="local"/>
<Speaker id="spk3" name="looser [Telefono] 2" check="no" type="dooo" dialect="native" accent="" scope="local"/>
<Speaker id="spk4" name="looser [Telefono] 0" check="no" type="fiiiiiiiiii" dialect="native" accent="" scope="local"/>
<Speaker id="spk5" name="looser [Telefono] 1" check="no" type="fiiiiiiiiii" dialect="native" accent="" scope="local"/>
</Speakers>
<Topics>
</Topics>
<Episode program="3dc56f411c1ac0a93cce14c97d1b1f88e49a9a2a428e4843" air_date="">
<Section type="report" startTime="0" endTime="605.22" length="605.220000">
<Turn speaker="spk1" mode="planned" fidelity="high" startTime="0.000" endTime="22.945" channel="studio">
<Phrase startTime="0.000" endTime="5.605">
<Token time="0.000" length="0.385" data="aaaa"/>
<Token time="0.385" length="0.700" data="bbbbb"/>
<Token time="1.085" length="0.230" data="cccc"/>
<Token time="1.315" length="0.400" data="dddd"/>
<Token time="1.715" length="0.180" data="ffffffeeeee"/>
....
Arquivo2:
<?xml version="1.0"?>
<Trans scribe="auto" version="0" version_date="">
<Speakers>
<Speaker id="spk1" name="looser [Telefono] 0" check="no" type="dooo" dialect="native" accent="" scope="local"/>
<Speaker id="spk2" name="looser [Telefono] 1" check="no" type="dooo" dialect="native" accent="" scope="local"/>
<Speaker id="spk3" name="looser [Telefono] 0" check="no" type="fiiiiiiiiii" dialect="native" accent="" scope="local"/>
</Speakers>
<Topics>
</Topics>
<Episode program="3dc56f431d47c0a93cce14cf7d1b1f88e7cb9a2a428c401a" air_date="">
<Section type="report" startTime="0" endTime="73.81" length="78.120000">
<Turn speaker="spk1" mode="planned" fidelity="high" startTime="2.645" endTime="5.145" channel="studio">
<Phrase startTime="2.645" endTime="5.145">
<Token time="2.645" length="0.180" data="oooo"/>
<Token time="2.825" length="0.460" data="yyyyyy"/>
<Token time="3.285" length="0.150" data="uuuuu"/>
<Token time="3.435" length="0.350" data="dddddssss"/>
<Token time="3.785" length="0.130" data="jjjjjjjjjjjj"/>
obrigado a todos.
