Documentation M.EXTRACT
M.EXTRACT
M.EXTRACT is the easiest way to identify small snippets of information from a longer document/piece of text.
M.EXTRACT takes a file or text and one or more prompts to extract information.
Examples
=M.EXTRACT(A2, "Full name of applicant")
=M.EXTRACT($A$2, "The revenue in 2024 quarter # :", B1)
=M.EXTRACT(A2, "Tell me the company's address in the city: ", C2)
Parameters
| Parameter | Type | Description |
|---|---|---|
| extractFrom | Text/Cell Reference | The file or text you'd like to extract the information from |
| prompt1 | Text/Cell Reference | The first entry of the prompt instruction for the extraction |
| [prompt2] | Text/Cell Reference | Optional additional prompt entries. Continue adding information as needed |
Note: Arguments can be either text or cell references, in any order after the first argument.