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 ?
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