>Is there a command the returns the opposite result of FIELD() Function? Because FIELD() returns the name of a field, referenced by number, in a table.
>
>I am looking for a function that returns the number of a field, referenced by name, in a table. Any such thing?
>
There's no native function to do this, but it'd be easy enough to extract the list of fields to an array using AFIELDS(), and then look for the field name in the array using ASCAN, which would give you the field number corresponding to the name.
Another approach would be to populate a Scripting.Dictionary object (part of the WSH) with the list of fields and their relative positions. You can search a Scripting.Dictionary object by item name.