Array with fieldnames
Robert van den…
Forums
I have a script to create an array with the fieldnames of a database. But for a check i need to exclude two fields of which i know the name. But is it possible to search the array for a match and remove that row in the array?
You can exclude them but it
You can exclude them but it would probably be easier to not add them to begin with. When you are going through the fields you could add an if statement to exclude them.
If fieldname <> "FIELD_TO_EXCLUDE" then
'add the field
end if
If you have the array already what you can do is create a second array, loop through the first array looking for the fields to exclude and then copy all the other field names to the new array, this way the new array won't contain any blanks.
Hope this makes sense.
Brian