Forum Discussion
Removing Text from a date column
I have a row that is meant to store the date when an item was launched. It is currently stored as a mix of just the date in format "1/10/19" or in the format "Launched-1/10/19" I want to remove every...
Try adding a custom column in the query editor with this formula. It will only keep the numbers and / from your text.
= Text.Select([DateTextColumn], {"0".."9", "/"})
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
Try adding a custom column in the query editor with this formula. It will only keep the numbers and / from your text.
= Text.Select([DateTextColumn], {"0".."9", "/"})
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat