Removing last character from a string using VB

BryanL

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.

KyleGonterwitz

Just FYI, another way to remove the right most string in VB is to use the String Reverse method, remove first string using left or mid, then use the string reverse again.

This is a method I have found handy for classifying Schools into Elementary, Junior High, Middle, and High Schools, because a list of schools usually has a format like "MARTIN LUTHER KING JR ELEMENTARY SCHOOL" or "JEFFERSON MIDDLE SCHOOL" so the string reverse method gives you an easy way to work from the right to left by reversing the characters so you are actually working left to right, without having to count characters or string parts.  Just make sure to reverse the text again so you arent showing anybody information that looks like "LOOHCS ELDDIM NOSREFFFEJ"