String to Integer conversion

[AKB]

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 -

[RolandSchubert · Accepted 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