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??