AnsweredAssumed Answered

Extracting Value from List to Field in Related Table

Question asked by benchwrm11 on Nov 27, 2012
Latest reply on Nov 27, 2012 by benchwrm11

Hi All,

 

I have a field that has a list which contains multiple catergory:subcategory:value, with each separated by an return. For example:

 

Emergent: Cattail: 1

CWD: CWD: 1

Open: NA: 98

 

There are 5 potential types categories, and 11 subcategories. I am trying to write a script or calculation that will extract each values to a specific field in a related table (i.e. Emergent Cattail goes to Emergent Cattail field, CWD goes to CWD field).

 

While I'm sure the correct GetField statement would get me there, I've been struggling to find it. Any help would be greatly appreciated.

 

Thanks!

Outcomes