Blob Text - Does AppSheet have a way to extract values based on field identifiers?

I am creating an automated process that grabs content from emails as they arrive (using Integromat). This allows me to capture the email body as a blob of text into a Google sheet.

Within this blob of text are a set of field identifiers with their corresponding values, like so:

...Field1: Value 1...Field 2: Value 2...Field 30: Value 30

I am looking for a way to parse the blob, find โ€œField1โ€ and then return โ€œValue 1โ€. Then repeat for the other fields.

I am kind of familiar with the OCR feature and understand the EXTRACTโ€ฆ() functions but it doesnโ€™t seem like these will help with this use case.

Is there anything within AppSheet that can parse the text blob in the manner described above?

0 5 800
5 REPLIES 5
Top Labels in this Space