extract start and end position using index function
Posted: Tue May 05, 2009 8:10 am
I have a sample data like this
"EMP_BASE_RATE=8.81","EMP_BIRTH_DATE=08/03/1987 00:00","EMP_FIRSTNAME=MANUEL","EMP_LASTNAME=BUENO","EMP_FULLNAME=BUENO, MANUEL","EMP_PAYGRP_NAME=PHASE1","EMP_SIN=removed","EMP_FLAG3=N","EMP_FLAG11=0","EMP_FLAG14=R","EMP_VAL1=H2SA002","EMP_VAL2=","EMP_VAL3=1982","EMP_VAL4=.25","EMP_VAL5=SA","EMP_VAL6=CA","EMP_VAL7=4175755","EMP_VAL8=IF0HO1","EMP_VAL17=CA","EMP_VAL20=G00S16"
From this i want to extract 3 values EMP_FIRSTNAME=MANUEL, EMP_LASTNAME=BUENO and EMP_FULLNAME=BUENO, MANUEL. I am able to get the start position for each of these using index function not able to get the last position. Can any suggest me please?
"EMP_BASE_RATE=8.81","EMP_BIRTH_DATE=08/03/1987 00:00","EMP_FIRSTNAME=MANUEL","EMP_LASTNAME=BUENO","EMP_FULLNAME=BUENO, MANUEL","EMP_PAYGRP_NAME=PHASE1","EMP_SIN=removed","EMP_FLAG3=N","EMP_FLAG11=0","EMP_FLAG14=R","EMP_VAL1=H2SA002","EMP_VAL2=","EMP_VAL3=1982","EMP_VAL4=.25","EMP_VAL5=SA","EMP_VAL6=CA","EMP_VAL7=4175755","EMP_VAL8=IF0HO1","EMP_VAL17=CA","EMP_VAL20=G00S16"
From this i want to extract 3 values EMP_FIRSTNAME=MANUEL, EMP_LASTNAME=BUENO and EMP_FULLNAME=BUENO, MANUEL. I am able to get the start position for each of these using index function not able to get the last position. Can any suggest me please?
Please don't post the same question in multiple forums, even if the first one was the "wrong" forum.