Column with varying string data wanting to be converted to numerical

[arundaka03]

Hi everyone. 

I have a data set with the following column. The column is currently STRING and I need it to be numerical. I think the TBD is preventing me from doing so using the Select tool, so I want to change the TBD to 0, then use Select to change the column to NUMERICAL. 

Or is there a better way of doing this?

Value

100000

150000

375000

TBD

50000

TBD

Thanks,

KA

[ChrisTX · Accepted solution]

Try one Formula tool.

IF [Value] = "TBD" THEN 0
ELSE ToNumber([Value])
ENDIF

Chris

[arundaka03]

Thank you, Chris!