Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
1 year ago
Solved

Delete Last Character from a Cell

Hello I have a cell with a piece of data, from which I need to remove the last character, which can be a number or letter, additionally not all cells have the same length, some have 9 characters...
  • Syndicate_Admin's avatar
    Syndicate_Admin
    1 year ago

    Well I looked for the solution in English, I apologize for it, I will publish it here in case someone helps you:

    1° I put add custom column

    2° use the following expression : Text.Start([RUT],Text.Length([RUT])-1)

    It worked for me, thanks anyway and excuse me.

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
1 year ago

Well I looked for the solution in English, I apologize for it, I will publish it here in case someone helps you:

1° I put add custom column

2° use the following expression : Text.Start([RUT],Text.Length([RUT])-1)

It worked for me, thanks anyway and excuse me.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi,Syndicate_Admin 
We are delighted that you have found a solution and are willing to share it.

 

Accepting your post as the solution is incredibly helpful to our community, as it enables members with similar issues to find answers more quickly.

 

Thank you for your valuable contribution to the community, and we wish you all the best in your work.

 

Best Regards,

Leroy Lu