TRANSFORM DATA

[Syndicate_Admin]

Hello, how to transform what is in date and pass it to Blank or 0

Thank you

[AlexisOlson · Accepted solution]

You could check if it contains a space or "/" or ":" and replace those.

Table.TransformColumns(
    #"Previous Step Name",
    {{"% CTOR", each if Text.Contains(_, " ") then null else _, type number}}
)

[v-jingzhang]

Great solution! Learnt a new trick!