I have a V_Wstring field containing the categories 'Left', 'Right' and [Null]. How do I convert these to numeric values, please, e.g. -1, +1, and 0?
Thx much -
Solved! Go to Solution.
Hi @AKB ,
you could use a formula tool and assign the values using the Switch function:
Switch([Field1],0,'Left',1,'Right', -1)
([Null] and all other values would be converted to 0 in the calculated field)
Other options would be a Multi-Field formula tool (same logic, but you can use the same field and convert it to a numeric field type).
Best regards
Roland