I have a problem with attribute table which I'd like to learn to solve without MS Excel.
The Shapefile I have, has an attribute field, which consists of 3 parts, separated by ";" -sign. Here is an example of what the original looks like, how it is split and how the final attribute should look like. Red is the original and Blue is what it looks like at the end.
So what I would like to do, is to edit "RATAOSOITE" with a single python or VBScript in Arcmap. The script should do the following:
a) remove the first number/text before the first ";" sign. b) change all empty spaces to "Underscore" and change the second ";" -sign to "Underscore".
I have next to no experience with scripting, so this maybe rather basic task is rather hard for me. I have done the same thing with Excel. Copy Attribute table to Excel --> text to columns by ";" --> replace "space" with "_(Underscore)" and "CONCATENATE(a1;Underscore;b1)" or something like that. But it would be great, if I could do this all in Arcmap Field Calculator.