Forum Discussion
Extracting Text Before Delimiter
I created a new column in Power Query by extracting "Text Before Delimiter". During my audit, there is a field within the column that I would like to update: "NULL" = [BLANK]. How would we be able to...
amitchandak Thank you for your support. I tried your suggestion but could not figure out how to add the command. After playing around with the column, "REPLACE VALUE" worked great.
Once again, thanks for your support!
Anonymous , Try a new column
try one of the two
=Text.Replace("Null", null)
=Text.Replace("Null", "")
amitchandak Thank you for your support. I tried your suggestion but could not figure out how to add the command. After playing around with the column, "REPLACE VALUE" worked great.
Once again, thanks for your support!