Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Splitting a Column into two

Lazzanova
7 - Meteor

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

1 REPLY 1
Luke_C
16 - Nebula

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:.*)

 

Luke_C_0-1630351395886.png

 

Labels