String function to remove the last character.

Is there a way, using String Functions, to remove the 'T' from "Wheat FarmingT" (no double quotes)? Note: Not all fields have T in the end only a few. If string function isnt possible, could any please suggest a regex for this? Example: Column name: Agriculture, Forestry, Fishing and Hunting Data is Wheat FarmingT where T is actually in a form of "to the power". Thank You.

Accepted answers

JoeS

Hi @Ghosh

You'll want to use the below function:

Substring([Field1],0,length([Field1])-1)

Which starts at the beginning of the field then goes on for the length of the field minus 1

If it is only one character?

All comments

JoeS

Hi @Ghosh

You'll want to use the below function:

Substring([Field1],0,length([Field1])-1)

Which starts at the beginning of the field then goes on for the length of the field minus 1

If it is only one character?

Ghosh

thank you for your reply and it helps.

Although I found out that there was an extra "Space" after the data in the fields. So I used 2 TrimRight functions to get them out.

Will make another copy of the data with your provided solution,

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15880

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703