0 Replies Latest reply on Apr 3, 2012 2:09 PM by jie.lin

    VB GIS Field Calculator

    jie.lin
      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??