Forum Discussion

hood2media's avatar
hood2media
Icon for Resolver II rankResolver II
3 years ago
Solved

power query to clear inconsistent strings in rows

hi, ref to "FLT_DATE" column (column-A) in the sample file here.    kindly advise on how to get rid of the time in the cells under the same column as i found that there are inconsistent i.e. some ...
Need Help
Show and Tell
  • CNENFRNL's avatar
    CNENFRNL
    3 years ago
    = Table.TransformColumns(#"Changed Type", {"FL_DATE", each Date.FromText(Text.BeforeDelimiter(_, " "),[Format="M/dd/yyyy"])})

CNENFRNL's avatar
CNENFRNL
Icon for Community Champion rankCommunity Champion
3 years ago
= Table.TransformColumns(#"Changed Type", {"FL_DATE", each Date.FromText(Text.BeforeDelimiter(_, " "),[Format="M/dd/yyyy"])})