Notes/Domino 4 and 5 Forum

Hi

I am trying to create script for the following scenario and was wondering whether someone could help to get my desired outcome

scenario explained below:

'lookup the view, do an FT search on tempdoc.StaffName, if ftsearch returns more than 1 doc found,
' tempdoc.StaffName appears twice, do some processing
'get the role value, the site and the division value from the view column values not the actual field for each of the documents found in the ft serach
'if role is same then do not create change control doc for All Role group & All APTC, All Probation Grade Staff
'if site is same then do not create change control doc for <Site> All Staff group
'if division is same then do not create change control doc for <Div> All Staff, <Div> DMT, <Div> Role group

i have tried the above as script below:

Dim viewview As NotesView
Dim viewdoc As NotesDocument
Set viewview = currentDb.GetView("ATestV3")

j = viewview.FTSearch( tempdoc.SMStaffName(0), 0 )


Set viewdoc = viewview.GetFirstDocument
counter% = 1
Dim column As NotesViewColumn
Dim people( 1 To 5 ) As Variant
Dim currentpeoplet As Variant

For i = 1 To j
currentpeople = viewdoc.ColumnValues( 0 )
people( counter% ) = currentpeople
counter% = counter% + 1
Set viewdoc = viewview.GetNextDocument(viewdoc)
Next

currentpeople(1) and currentpeople(2) returns an array of values which I KNOW WILL contain
the value conatined in tempdoc.SMStaffName(0), but how do i do this...i tried item.contains but that did not work....what do i need to do to get the value i require...the issue also here is that

currentpeople(1) may contain for eg:
"John Smith~ACO" but tempdoc.SMStaffName(0)would equal "John Smith" only...so i need to somehow do an @Left in script and then do that @contains in script

can someone please help.

Thanks in advance