Showing results for 
Search instead for 
Did you mean: 
Community Support Team
Community Support Team

Re: Create new column based on text from a messy text blob

Hi @Zelbinian,


I'm glad it can work. Firstly, we need to find the pattern that the computer can recognize. Secondly, find a function here that can do the job. 

The functions will iterate every character of the parameter till the second delimiter or the end. So it won't be a problem if the second delimiter doesn't exist.


Best Regards,

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.