Column Find (COL.FIND)

=spac.COL.FIND( searchTerm, resultType, limit, offset )

Searches for a column based on a search term and returns a dynamic array of values.

Parameters

searchTerm

The search term to use to find the column.

resultType

The type of result to return. This can be either "web" or "api". Defaults to "web" if not specified.

limit

The maximum number of rows to return. Defaults to 10 if not specified. The limit must be a positive integer.

offset

The number of rows to skip before beginning to return rows. Defaults to 0 if not specified. The offset must be a non-negative integer.

Examples

What are all columns that contain the word "date"?

=spac.COL.FIND("date", "web", 100)

What are all columns that contain the word "projection"?

=spac.COL.FIND("projection", "web", 100)

What are all the columns that contain "IPO"?

=spac.COL.FIND("ipo", "web", 100)

What are all the columns that contain "DeSPAC"?

=spac.COL.FIND("despac", "web", 100)