:) sure, you build these from the inside out as you iterate the formula. I did not do this in one pass.
Left(Right(NotRight([My Field],1),">"),"<")
NotRight([My Field],1) // this lops off the last character (Not Right) as I saw it was a > and I later would need to extract up to the > character but not counting that last >.
That would have given this
<?xml version="1.0" encoding="utf-x"?> <string xmlns="http://www.tempuri.org/">1234</string
Then next step to wrap that with a Right formula was this
Right(NotRight([My Field],1),">")
That says to take the Right of the string (think pacman eating from the right) so far but stop at the first >
that would have given this
1234</string>
Then we wrap that in Left
Left(Right(NotRight([My Field],1),">"),"<")
so that will come at the string now from the left and pacman up to the first < thus leaving
1234
It is good that you're asking and what I suggest you do is go ahead and remake that formula in pieces starting from the inside out as I described and then observe the string getting reduced either from the left or the right until you are just left with 1234
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.commark.shnier@gmail.com
------------------------------
