Text to Column

elaenscetric

I was having a field like Field1:Field2@Field3

Now I need to split this into 3 columns like Field1, Field 2 & Field3 using : , 

I have done this using TextToColumns tools. Now issue my second field may contain @ symbol and so I don't want to consider that as delimiter. For example Field1:Field2@@Field3 should be split likeField1, Field2@,  Field3

Anything using Formula for this ?

OllieClarke

Hi @elaenscetric you can use RegEx to parse the 3 columns:

([^:,@]+?)[:,@](.+)[:,@]([^:,@]+)

 This will find parse into column1 everything up to the first one of ':,@' and parse everything from the final ':,@', and everything between them will come out as column 2

Hope that helps,

Ollie