I’ve got Panorama parsing a sizable XML form very reliably in nearly all instances. Typically the tags are clear and easy to pull apart using TagData: TagData(XML,"<head>","</head>",1)
The exception is when extra notes or parameters have been added inside the opening tag. For instance: <head typecode="123" ref="321">.
I can alter my filter to TagData(XML,"<head","</head>",1) and catch them, then find the > and take it from there.
It just feels clumsy though, especially since it involves hundreds of different tags. Is there some trick I’m missing that can see the opening tag as a whole?
Since this is “Classic” and regular expressions are not an option, I doubt if there is much you can do to improve on what you are doing. Tagdata( doesn’t have any provision for wild cards, so two nested functions is probably the best you can do.
A clever solution. I had been planning on using a text funnel. Since I have hundreds of lines of these formulas I’ll run a couple through a loop to see if one or another method is faster.