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 do that in Power Query? Below is sample data: Table 1 = Current Output / Table 2 = Expected Output.
(Table 1 = Current Output)
| Labels | Labels Bucket |
| NULL | NULL |
| 1,2 | 1 |
| 2,3,4 | 2 |
| 15,99,2000 | 15 |
(Table 2 = Expected Output)
| Labels | Labels Bucket |
| NULL | |
| 1,2 | 1 |
| 2,3,4 | 2 |
| 15,99,2000 | 15 |
Any advice is greatly appreciated.
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!
2 Replies
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!
