The XPath function max works great on numbers without punctuation. For example, max(//Mem_Usage) provided that there is a Mem_Usage column that will look like 1, 1578, or 1039274.
However, if those values are 1, 1,578, and 1,039,274 then all bets are off. I just get back NaN (not a number).
Any ideas on how to:
- Have iTest ignore the comma's, so the structured data has just the numbers? A custom parser maybe? I'm using a Pattern map if that matters.
- Write a more intelligent XPath statement so that commas will be stripped for the node-set sent to max? I've tried translate, but can't get it to work in conjuction with max; node-set/string value mismatch.
- Any other ideas?
This seemed trivial at first glance, but I've spent hours now and I'm totally stumped! :-(