I have a field on my events that has the following:
john,12345,mark,2356,maria,4567
rachel,8883,john2,488475
nothing to report
NULL
peter,9993
I am trying to create two fields from this. Field1 is called employee, and field2 would be employeeid. I want my end product to look like this:
employee=john
employeeid=12345
employee=mark
employeeid=2356
...
employee=peter
employeeid=9993
The problem is that sometimes the events have 1 employe, other times more then one, and the field can also be empty.
I have been trying to achieve this with makemv or extract|kv with no successful results.
How would you guys/gals go about getting this done?
... View more