Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Replacing string with null in power query

Hey there   I'm trying to replace a text string in power query with power query's standard null value. However, whatever the text I try to replace with the null all I get is the same value all over...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    4 years ago

    Hi, Anonymous 

    The second part you mentioned is not empty. This means that you have at least one space character in your text.

    If possible, you should first replace ' ' with '' as follows:

     

    = Table.ReplaceValue(#"Renamed Columns"," ","",Replacer.ReplaceText,{"Column3"})

     

     

    Best Regards,
    Community Support Team _ Eason

v-easonf-msft's avatar
v-easonf-msft
Community Support
4 years ago

Hi, Anonymous 

The second part you mentioned is not empty. This means that you have at least one space character in your text.

If possible, you should first replace ' ' with '' as follows:

 

= Table.ReplaceValue(#"Renamed Columns"," ","",Replacer.ReplaceText,{"Column3"})

 

 

Best Regards,
Community Support Team _ Eason