Grabbing multiple string lines from an excel sheet

[Inactive User]

Okay so I am trying to grab multiple strings at once. These are in a excel file but each line is in a separate row.  

Unwanted TEXT/DATA

Description: ~~~~~~~~TEXT~~~~~~~~~~~~~~

                     ~~~~~~~~TEXT~~~~~~~~~~~~~~

                     ~~~~~~~~TEXT~~~~~~~~~~~~~~

                     03/21/2020

Unwanted TEXT/DATA

Description: ~~~~~~~~TEXT~~~~~~~~~~~~~~

                     04/15/2020

Unwanted TEXT/DATA

Description: ~~~~~~~~TEXT~~~~~~~~~~~~~~

                     ~~~~~~~~TEXT~~~~~~~~~~~~~~

                     02/23/2020

Unwanted TEXT/DATA

So when i try to grab/filter description it only gets the first string  line. I have multiple descriptions I have to get and they all vary in size the only thing they all have in common is that they end with a date.  Is it possible to grab the strings/text in between Description and the date? 

[Jonathan-Sherman]

Hi @Inactive User,

You could use Regex in parse mode to extract the data between the strings:

Description: (.*?)\d+\/\d+\/\d+

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan

[Jonathan-Sherman · Accepted solution]

Hi @Inactive User,

I think i may have misinterpreted the input in my first post so i've amended the workflow slightly to group and concatenate each string together.

If this solves your issue please mark the answer as correct, if not let me know! I've attached an updated workflow for you to download if needed.

Regards,

Jonathan