Forum Discussion
Split colum. Custom delimiter based on dynamic value
Hi there. I hope someone can help me. I am working in a customer service centre and I need to extract fom a text column, thetime when one of the agents makes the first response to each case. Th...
ronrsnfld
Super User
Super UserIn your title, you write about "Split Column", but in your question, you write you want to "extract" something from the text string. Assuming it is the latter, and you want just that first date, you could use Text.Split with space as delimiter and just return the first item in the list.
Hi.
Thank you for your message 🙂
The first date, neither the last is not the one I am trying to extract.
The one I need is the latest from the person in the column [Assigned to] which also include the text " (Additional commets)". Sometimes it can include other text as "(Working notes)", which is not what I need. That is why I created the column [Delimiter].
Thank you.