topic Re: Removing last character from a string using VB in Python Questions

Removing last character from a string using VB

BryanL — Wed, 09 May 2018 00:47:12 GMT

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.

Re: Removing last character from a string using VB

DanPatterson_Retired — Sat, 11 Dec 2021 23:47:44 GMT

Set the python parser in the field calculator. VB is no longer supported, so begin to learn Python and Arcade

# ---- examples
a = 'Apple.'

a.replace('.', "")
Out[163]: 'Apple'

a = 'Pear'

a.replace('.', "")
Out[165]: 'Pear'‍‍‍‍‍‍‍‍‍‍

Now for your field calculation you simply need to include the fieldname in ! ie !OriginalData! and calculate values preferably in a new text field ... like

!OldField!.replace(".", "")  # ---- no spaces between the double quotes‍

Re: Removing last character from a string using VB

BryanL — Wed, 09 May 2018 02:49:51 GMT

Hi Dan,

Appreciate the fast reply.

I gave it a go and noticed it didn't work...not too sure if I got it right.

Cheers

Re: Removing last character from a string using VB

DanPatterson_Retired — Wed, 09 May 2018 03:30:23 GMT

Why aren't you using the field calculator? (right-click on the field you want to calculate values for and follow on)

In any event

Field name is the field you are calculating into.

The field name used in the expression is the one that contains the old data and it should be different than the field name

Re: Removing last character from a string using VB

BryanL — Wed, 09 May 2018 03:41:17 GMT

I'm actually doing this in the model building environment..taking the input field, removing the trailing "." if any and replacing the new values into the original field

Apologies for any confusion caused. Just started exploring ArcGis.

Re: Removing last character from a string using VB

DanPatterson_Retired — Wed, 09 May 2018 03:46:39 GMT

Bryan ... switch the parser to python and set it to string. It isn't a good idea to replace an existing field, add a new field prior to this step and use it to house the results.

Re: Removing last character from a string using VB

TedKowal — Wed, 09 May 2018 14:46:35 GMT

IN VB:

IF right([Field],1) = "." then

[Field] = Trim(Left([Field],LEN([Field])-1))

ELSE

[Field]=Trim([Field])

END IF

Re: Removing last character from a string using VB

BryanL — Thu, 10 May 2018 02:15:28 GMT

Hi Guys,

Thanks for the help. Appreciate it a lot.

I've since managed to get the result I wished for.

Cheers

Re: Removing last character from a string using VB

KyleGonterwitz — Thu, 28 Jun 2018 18:47:25 GMT

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"