Grabbing multiple string lines from an excel sheet

Question

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~~~~~~~~~~~~~~

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 · Accepted Answer

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