Parse data that comes in one field

[young351]

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?

[Felipe_Ribeir0]

Hi @young351 

You can do that using regex expressions. See the attached example

Input:

Output:

[Emmanuel_G]

@young351 

Find in attachement a way to do that.

I did a test with dummy data.

[Felipe_Ribeir0]

Hi @young351 

It worked?

[young351]

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.

[Emmanuel_G · Accepted solution]

@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.