Hello everyone! Very new to the GIS industry, but I'm hoping to learn more down the line. Forgive me if this is a very basic question.
Right now I'm having trouble doing something I think should be very simple. I'm just to replace a string in a field with another string using the Field Calculator. However, every time I run the calculation absolutely nothing appears to happen to the records within the field in question. I am working with ~4,000 records and some of them have unnecessary leading zeroes in them. Normally I would run a calculation that would remove all the leading zeroes but certain records need it while others don't. As a result, I thought it would be easier to just entirely replace the ones that have the unnecessary leading zeroes.
Here is what I'm entering into the Field Calculator
DATE_TEXT
= Replace([DATE_TEXT], "011/12/2014","11/12/2014")
The numbers are both set to strings and I have made sure to check the VB Script parser. I've also tried it using the Python parser:
DATE_TEXT
=!DATE_TEXT!.replace("011/12/2014","11/12/2014")
But with no luck. What am I doing wrong? Is it the settings? I'm working with a standalone shape file in Arc 10.3.
