Making a calculated column from a string to a integer

In my data set I need to make a indicator column, I am trying to do this thorugh the add calculated column and when I make the column it comes out as a string.  I know its doing this becasue the column that I am using is a string.  What I want, is to make a column that goes from 'AC' to '1' for example.  Do you have any suggestions?



File string_to_integer_example.docx30.29 KB

(1) Answer