rwengewicz

How to make a Custom table.

Discussion created by rwengewicz on Aug 13, 2008
Latest reply on Aug 19, 2008 by RSA Admin

I pulling from a oracle DB, and one of the fields has a bunch of data that I would like to break up.

__65__RES_TK_TYPE=RSA SecurID Key Fob;;__65__RES_TK_NUM_DIGITS=6;;

__65__RES_TK_ASSIGNED_TO=xxxxxxx;;__65__RES_TK_LOST=N;;

__65__RES_TK_ENABLED=Y;;__65__RES_TK_NEW_PIN_MODE=N;;__65__RES_TK_LAST_LOGIN=20080812135300;;

__65__RES_TK_TOKEN_BIRTH=20071204190000;;__65__RES_TK_TOKEN_DEATH=20130330190000;;

 

What I need out of this string is;

 __65__RES_TK_ASSIGNED_TO=xxxxxxx

__65__RES_TK_LAST_LOGIN=20080812135300

 

the __65__RES_TK_ASSIGNED_TO=xxxxxxx, will need to be tied back to another table that when the data is updated in the parent table this table is updated also. Is there a way of doing this.

Outcomes