This data is coming from .xlsx in one field per column/per row. I only need the last three pieces, Date - Vendor - Gen ID.
Can someone give me some tips in order to Parse all of the data above out?
@young351
Find in attachement the way of doing that with this input.
It works even if you want to separate your data into rows or columns.
Hi @young351
You can do that using regex expressions. See the attached example
Input:
Output:
Find in attachement a way to do that.
I did a test with dummy data.
It worked?
I almost have it, but... it looks as if it is parsing the first 5 lines so I want to parse the first 5 lines through where the http: string ends out. I do not need any of that. Then where I have it marked in green, this is the info I want to separate into columns.
