topic Trying to calculate values from a text field to a double field in Data Management Questions

Trying to calculate values from a text field to a double field

Pierre-LucFaucher — Wed, 20 Jul 2011 17:19:14 GMT

Hi,
I need help, I'm trying to do an "Field Calculator", to get values from a "text" field to a new field with data type "Double"? Seems to be working but the thing is that I have some numeric values with letters in it! Example : P4593. So the thing is that when my values are calculate, those one are represent by 0.
Is there a Script that can help me to calculate my values correctly?
Thx for helping me and sorry for my English!

Pierre-Luc

Re: Trying to calculate values from a text field to a double field

Robert_LeClair — Wed, 20 Jul 2011 18:45:07 GMT

Pierre-Luc,

If all your text/string fields have the same format, P4593, for example. Then you could use the Right VB syntax to extract the 4 right most characters. In this case my formula would be:

NewField = Right ( [StringField], 4)

This would extract the right 4 "characters" --- 4593 --- and put it into the Double field. If the [StringField] is like P45931, then you would update the formula to be:

NewField = Right ( [StringField], 5)

Then 45931 is calculated into the NewField field.

Hope this helps!

Robert LeClair
Esri-Denver

Re: Trying to calculate values from a text field to a double field

RuthEmerick — Wed, 20 Jul 2011 18:48:31 GMT

Double is a data type that does not support non-numeric characters (other than a decimal point). Would striping the alphabet characters and just having the number in the field meet your needs?