jie.lin

VB GIS Field Calculator

Discussion created by jie.lin on Apr 3, 2012
I want to clean my field data using VB script
field (company aa, company aa f, company aa c, company bb, company bb1)
Desired Field1(company aa, company bb)

Dim sOldVal As Variant
Dim sNewVal As String
sOldVal = [field]
If Instr(sOldVal, "'company aa ") >0 Then
sNewVal = "aa"
End If

field1=
sNewVal
It doesnot work??

Outcomes