WIldcard field name in collection

[StefanFrederiks]

Hi Is it possible to search for a specific field that is dynamic in a Collection? Its not working with "name*" or "name%"

[StefanFrederiks]

Maybe index field names?

[John__Carter]

There is no search function but there is a Get Collection Fields action in the collections utility. You could also take a 'brute force' approach and simply try to read the field: if it works, then you know the field exists; if an exception occurs, handle it with recover/resume, and then you know the field does not exist.

[StefanFrederiks]

But I dont know all the different names. So brute forcing is not an option. Is it not possible to select the field by number? It has the same number of order everytime.

[John__Carter]

There's no index option currently available, but you could create one with a code stage. A collection is represented as a .Net DataTable in a code stage, so you could come up with something similar to the Read Collection Field page in the collection utility object.