RX Replace not working as expected

Hi,

 

I am trying to use RX Replace for the following type of data

Level/First/Product

/First/Product

Level-One/First/Product

 

I want to separate out each word into a separate data column, Column-1 Level, Column-2 First, Column-3 Product

I am using the following expression

 

RXReplace([Classification],"^(.*)////(.*)////(.*)////.*$","$1",""). Can someone tell me what is wrong with my expression.

 

Thanks

AK

(1) Answer

Login