I need some guidance in extracting metadata from a field.
There are two fields TYPE and VALUE. TYPE field has Name of the group, Duration of incident and State of an incident.
Value Field displays all data related to each of the dimensions in the TYPE field. I need to display these three dimensions from the TYPE field separately... any help would be highly appreciated.
Can you give a more detailed example of the field content? Is there any separtor in the field that distinguishes for example the name and the duration of the incident?
If there is a separtor , you could use functions such as SubField(), LEFT(), Right(), Mid() to extract the different content from a single field.