today we will search for specific tests within a field
for example we have her number email address is here that has have
University in signias at the end we would like to be able to look at the
email address and then figure out what university that go to
we are going to use the search function now the search function will return the
starting position of the text within the field so we'll go equals search and we
we will type in UofA we are going to search withint his field here now press Enter
so we return the value of nine so now we wanted if it finds the text we wanted to
put the actual University name here instead of the nine so what we're gonna
do is we're gonna add it if function to the search so we're gonna start here and
if infront of the search and then so now this is greater than zero so that he finds the
Text it will be greater than 0 and it's going to place the actual name of the university
here
so there you have it down for the next universities it's going to give you an
error message because he didn't find it now how you're going two goals from one
text their error in front of this week so we can go front of the original
values will go if it brings you back in error then it's going to search for the
next 10 let's do you still get and then we'll start another so if this one
returns of errors and go to the next one will also give you an error if it's
wrong so let's go
yes and we'll go for you and we'll go then we're gonna grow search and then we
would call and then we selected field which is going to be the same field and
then we go and then we'll go so this is greater than 0 saluted finds it will be
greater than 0 and then it's gonna plays
university so its unique
Rapids 12 you have that works so let's drag down for the rest there you have it
there you have it
searching for specific tasks within fields