Forum Discussion
Split colum. Custom delimiter based on dynamic value
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.
Just add a custom column using the Text.Split function. The delimiter can be the string you select from the other column. EG based on your screenshot, the custom column formula might look like =Text.Split([Case Comments],[Delimiter]). Then you can examine the resultant List to see which item contains the earliest date.
If you need more help, I suggest you post a realistic example that shows the variability in your data. Be sure to post it as TEXT which can be copy/pasted. Screenshots are virtually useless for this.