topic Re: Removing trailing character in a string in ArcGIS Online Questions

Removing trailing character in a string

BryanL — Wed, 09 May 2018 02:24:00 GMT

Hello All,

I would like to get some help on the following issue that I encountered in ArcGis 10.3

The objective is to look through the whole string and remove just the "." from the string

Object ID Field

1 Apple.

2 Orange.

3 Egg

4 Pear

5 Watermelon

I've tried using the following code which resulted in the all the last characters being removed instead of just "." :

Trim( LEFT ([Field], LEN( [Field]) -1))

I've also tried the code below which prompted an error message "Type mismatch" for both iif and InStr :

Trim(Left([Field], iif((InStr([Field], ".") = LEN([Field])), InStr([Field], ".")-1, LEN([Field]))))

I am using the Field Calculator in ArcGis 10.3.

Thanks for any help in advance.

XanderBakker — Wed, 09 May 2018 12:32:25 GMT

Use the Python parser and this:

!YourFieldName!.rstrip('.')‍

RobertScheitlin__GISP — Wed, 09 May 2018 12:32:40 GMT

Bryan,

You could use

Replace([Field], ".", "")

BryanL — Thu, 10 May 2018 02:12:07 GMT

Thank you guys for the help. Appreciate it.

I 've since managed to get the result.

Cheers