Extract date from parenthesis

If your desired date/time is always inbetween 3rd pair of parenthesis, you can add step below...

= Table.AddColumn(PriorStepName, "Custom", each Text.BetweenDelimiters([TextColumnName], "(", ")", 2, 0))

If not you might do it relative to "TEXT_EXAMPLE3" position...

= Table.AddColumn(PriorStepName, "Custom", each let l=List.Transform( Text.Split([TextColumnName]," "), each Text.Remove(_,{"(",")",","})), i=List.PositionOf(l, "TEXT_EXAMPLE3") in l{i+1} & " " & l{i+2} )

Hi  modwonka ,

Previousstep refers to the previous applied step,not the column.

Take below steps as example:

Now if you wanna create a new step,then "Added Custom" is the previous step.

Check my .pbix file attached.

Best Regards,
Kelly

Did I answer your question? Mark my reply as a solution!