Amigos preciso montar uma ER que busque a chave por exemplo “0000088C” e que traga tudo que estiver entre as tags e .
Buscando “0000088C” deve retornar apenas:
[code]
[/code]Buscando “0000087C” deve retornar apenas:
[code]
[/code]Texto Completo
<Package>
<Header Reason="0" Id="198" Version="1.0"/>
<Control Provider="" CPRDateTime="2012/02/08 11:58:32" Account="2" MsgId="211" Port="3000"/>
<TCA ProductId="22" SerialNumber="0000087C" VersionId="0.1"/>
<Datagram MsgType="STATE" MsgDateTime="2012/02/08 10:58:29"/>
<GPS SatNum="8" Speed="68" DateTime="2012/02/08 10:58:28" NorthAngle="293.0" AltitudeStatus="VALID" PosIsValid="TRUE" Lat="-25.54156" Long="-48.68713" CableStatus="OK" Altitude="18"/>
<Comm RSSI="0" GPSType="INTERNAL"/>
<LinearInput Speed="0" Odometer="0" RPM="0" Temp1="127" BackBattery="40" Temp2="127" Temp3="127" MainBattery="26"/>
<Input Movement="ON"/>
<Output/>
<Event Movement="ON" EventDateTime="2012/02/08 10:58:28"/>
</Package>
<Package>
<Header Reason="0" Id="198" Version="1.0"/>
<Control Provider="" CPRDateTime="2012/02/08 11:58:32" Account="2" MsgId="211" Port="3000"/>
<TCA ProductId="22" SerialNumber="0000088C" VersionId="0.1"/>
<Datagram MsgType="STATE" MsgDateTime="2012/02/08 10:58:29"/>
<GPS SatNum="8" Speed="68" DateTime="2012/02/08 10:58:28" NorthAngle="293.0" AltitudeStatus="VALID" PosIsValid="TRUE" Lat="-25.54156" Long="-48.68713" CableStatus="OK" Altitude="18"/>
<Comm RSSI="0" GPSType="INTERNAL"/>
<LinearInput Speed="0" Odometer="0" RPM="0" Temp1="127" BackBattery="40" Temp2="127" Temp3="127" MainBattery="26"/>
<Input Movement="ON"/>
<Output/>
<Event Movement="ON" EventDateTime="2012/02/08 10:58:28"/>
</Package>
<Package>
<Header Reason="0" Id="198" Version="1.0"/>
<Control Provider="" CPRDateTime="2012/02/08 11:58:32" Account="2" MsgId="211" Port="3000"/>
<TCA ProductId="22" SerialNumber="0000087C" VersionId="0.1"/>
<Datagram MsgType="STATE" MsgDateTime="2012/02/08 10:58:29"/>
<GPS SatNum="8" Speed="68" DateTime="2012/02/08 10:58:28" NorthAngle="293.0" AltitudeStatus="VALID" PosIsValid="TRUE" Lat="-25.54156" Long="-48.68713" CableStatus="OK" Altitude="18"/>
<Comm RSSI="0" GPSType="INTERNAL"/>
<LinearInput Speed="0" Odometer="0" RPM="0" Temp1="127" BackBattery="40" Temp2="127" Temp3="127" MainBattery="26"/>
<Input Movement="ON"/>
<Output/>
<Event Movement="ON" EventDateTime="2012/02/08 10:58:28"/>
</Package>
Alguém consegue montar esta ER, Obrigado!