With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.

Monday, July 2, 2018

yogi_Populating different pieces of text from a single cell into various other cells

question by: Mark McGill ABODO
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/f2ZSrx76C10;context-place=mydiscussionsPopulating different pieces of text from a single cell into various other cells?

I currently have Sheets integrated with an automated Slack channel that collects all customer submissions of a form on our website. The integration puts all of the Slack text into a single cell, but I'm looking to get specific peaces of info from the text in those cells to be separated out into other cells automatically. The text is coming into column A, and always follows the same template:

id:

name:

email:

created_at:

I don't think I can use the Choose/Match functions as each text entry into column A will have unique values for each of the above fields. Is it possible to functionally generate whatever text follows 'id:' into column B, whatever text follows 'name:' into column C, etc. From what I've read online it seems like this may be possible with one or both of the RegexMatch and RegexReplace functions, but admittedly they're both way over my head.

I think one of the main curveballs here is that there is not a standard number of characters that will be in each of those fields in the column A text. Any help is greatly appreciated!