XPATH To filter out records with letters

Escaskmaw

New Member
I am looking for an XPATH expression that will perform a search to ensure a field does not have a letter in it. For example input XML:\[code\]<?xml version="1.0" encoding="UTF-8"?><payload> <records> <record> <number>123</number> </record> <record> <number>456</number> </record> <record> <number>78A</number> </record> </records></payload>\[/code\]I want it too filter out the third result as it has a letter in the tag. So return this:\[code\]<?xml version="1.0" encoding="UTF-8"?><payload> <records> <record> <number>123</number> </record> <record> <number>456</number> </record> </records></payload>\[/code\]Is that possible to do in a simple XPATH?So something like \[code\]/payload/records/record[reg expression here?]\[/code\]@CylianThis is what i mean:\[code\]<?xml version="1.0" encoding="UTF-8"?><payload> <records> <record> <number>123</number> <time>12pm</time> <zome>UK</zome> </record> <record> <number>456</number> <time>12pm</time> <zome>UK</zome> </record> <record> <number>78A</number> <time>12pm</time> <zome>UK</zome> </record> </records></payload>\[/code\]
 
Back
Top