Forum Discussion

PhilippeMuniesa's avatar
PhilippeMuniesa
Icon for Resolver I rankResolver I
5 years ago
Solved

Text.TrimEnd Replace I can't remove spaces from a column

Hello,   I am getting bank statements, and I want to remove all spaces from the label column .... I tried TrimEnd,..   Text.TrimEnd([Libellé])   I tried ReplaceValue    Table.ReplaceValue(AjL...
Need Help
  • BA_Pete's avatar
    BA_Pete
    5 years ago

    Hi PhilippeMuniesa ,

     

    Your M code should look like this:

    Table.ReplaceValue(AjLibelle," ","",Replacer.ReplaceText,{"Libelle"})

     

    Pete 

  • Anonymous's avatar
    Anonymous
    5 years ago

     

    If you are trying to accomplish this, you need to use the syntax you see in the image

     

     

     

BA_Pete's avatar
BA_Pete
Icon for Super User rankSuper User
5 years ago

Hi PhilippeMuniesa ,

 

Your M code should look like this:

Table.ReplaceValue(AjLibelle," ","",Replacer.ReplaceText,{"Libelle"})

 

Pete 

PhilippeMuniesa's avatar
PhilippeMuniesa
Icon for Resolver I rankResolver I
5 years ago

thank you,

 

it is indeed the double quote that causes the problem, however it is the interface of the powerquery editor of excel which offers this syntax.

I ended up bypassing the problem with Text.FromNumber (32),

 

thank you very much for your two answers