How about something like:
word(string,( wordpos('K3',string) + 1 ) )
On 08/03/2010 03:09 PM, Leland Lucius wrote:
I know, I'm probably being stupid here, but I just can't seem to figure it out.
Given something like:
K1 V1 K2 V2 K3 V3 K4 V4
I want to be able pipe that "V3" to a VAR stage. But it needs to be relative to where
"K3" is so that:
K3 V3 K1 V1 K2 V2 K4 V4
would find "V3" as well.
Thanks,
Leland
--
Rich Smrcina
Phone: 414-491-6001
http://www.linkedin.com/in/richsmrcina
Catch the WAVV! http://www.wavv.org
WAVV 2011 - April 15-19, 2011 Colorado Springs, CO