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(AjLibellé,""" ""","",Replacer.ReplaceText,{"Libellé"})

I cannot get rid of the spaces, however, once in Excel, the function replace "" by nothing, works correctly.

Attached is a Dropbox link of a folder that contains

An example of a recovered CSV file,

a CsvToXLViaPQ folder which contains the Excel file with the PQ request

The relevant query under development is called CC

Thank you in advance for any help you can give me

Philippe Muniesa

BA_Pete
5 years ago
Hi PhilippeMuniesa ,

Your M code should look like this:

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

Pete
Anonymous
5 years ago

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

BA_Pete
Super User
5 years ago
Hi PhilippeMuniesa ,

Your M code should look like this:

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

Pete
- PhilippeMuniesa
  Resolver 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
Anonymous
Not applicable
5 years ago

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

Forum Discussion