Forum Discussion
massotebernoull
Helper I
4 years agoReplace multiple words in a row
Hello, I'm struggled with this replacement: I have this table: Original TRY1 TRY2 Non-qualified Non-qualified Non-qualified Non-qualified Non-qualified Non-qualified ...
- 4 years ago
Ah, I think the issue must be earlier then.
Try putting the null check in earlier:
Text.Combine( List.Transform( Text.Split(if [Original] = null then "" else [Original], ","), each if _ = "100000011" then "Declared bankruptcy" else if _ = "100000014" then "Filantropic school" else if _ = "" then "non-qualified" else "Verify" ), "," ) )
massotebernoull
Helper I
4 years agoThanks for your reply. It worked fo the lines with multiple itens, but it didn't work for the lines wich have "null" values. I'm sorry I miss specified instead of replace "" to "Non-qualified", I want to replace null to "Non-qualified". When I use your formula, I get error in null values. Is there a way to do this whitout adding more steps?
mussaenda
Community Champion
4 years agoHi massotebernoull ,
from the reply of AlexisOlson ,
You can replace "" to null and position it as the first argument.