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?
User | Count |
---|---|
18 | |
12 | |
8 | |
4 | |
3 |