Forum Discussion
Extract multiple dates from a single free text value
Hi All, I am looking for a more elegent way to extract dates, times and notes from a free text field. Essentially it is a ticket work notes history concated into a single value at the header leve...
For date, use following formula (logic is same as yours but wrapped in a formula). You will get a list. You can make a decision to extract to rows or in a column separated by say comma (The formula can be wrapped in Text.Combine as well)
= List.RemoveNulls(List.Transform(Text.Split([Data]," "),(i)=>try Date.From(i) otherwise null))For time, same line of logic
= List.RemoveNulls(List.Transform(Text.Split([Data]," "),(i)=>try Time.From(i) otherwise null))For Note, what is the expected output from your given sample?