AnsweredAssumed Answered

Removing last character from a string using VB

Question asked by BryanL_88 on May 8, 2018
Latest reply on May 9, 2018 by BryanL_88

Hi All,

 

I'm trying to remove "." from various string of different length and would be great if anyone could advise or correct me on the right VB code.

 

Example of the data that I am using are as follows;

 

Apple.

Orange.

Pear

Salade

Lime.

 

Some of the string above have a "." at the back while others don't and they are all of different Length. The code I've written below simply take away the last character regardless if they are "." or not. Would be great if anyone could help me with this.

 

rTrim( Left ([MACodeLongDescription], LEN([MACodeLongDescription]) -1))

 

Thank y'all in advance.

Outcomes