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?
Solved! Go to Solution.
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
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