Splitting a Column into two

[Lazzanova]

Hey guys,

I've got a column containing two urls concatonated to each other. 

I'm trying to split these two url's into two seperate columns.

Example of what is contained within a cell:

https://blablabikes.jpghttps://blablabikes-2.jpg

I tried using Trimleft and right. I puzzled a bit with the RegEx function as well. But I haven't been able to solve this one.

Any help would be much appreciated.

With kind regards,

Lazzanova

[Luke_C]

Hi @Lazzanova 

I think your example data was cutoff, but I tried to simulate by copying it into the same cell twice. Regex parse should do the trick. Basically it is looking for the 'https:' pattern to split it. If there's a delimiter in the cell already then it's much easier with the text to columns tool. If some urls are only http then the solution also changes slightly.

(https:.*)(https:.*)