I want to do some advanced level scripting with VBA in the field calculator. I have done a simple coding in the code block. Here is the codes.
dim X if [Name]="University" then X=101101 elseif [Name]= "College" then X=101102 elseif [Name]= "Medical College" then X=101103 elseif [Name]= "School" then X=101104 else X="" end if
This is working correctly. But I want to do something more. Those are-
- If the Name field contain the word University or College or Medical College or School then X return the expecting value.
- Is it possible to create new fields through VBScript? If its possible then the X will split into two from its middle (3-3) and put the value in the newly generated column/fields.
If this possible it will help me a lot.
Thanks in advance