General Discussions

Discuss any topics that are not product-specific here.
SOLVED

How to use " text to column" tools in alteryx?

selinunlu
7 - Meteor

 

Hi everyone,

 

I want to separate text inside the column. I always use "text to column" tools on excel cause slash is discriminator "/" . 

I only want the text after the latest slash fx: / KARTUS BEDELI 

Can anyone help me figure out ?

selinunlu_0-1647352882486.png

 

1 REPLY 1
JosephSerpis
17 - Castor
17 - Castor

Hi @selinunlu regex might be an approch to use to reslove this challenge as you can parse out everything after the /. I have mocked an example to showcase this.

 

Regex_15032022.JPG

Labels