Remove Last 10 characters of text in a field

[evansabres]

Hello -

I have a field name, called [Line item]. I want to trim the last 10 characters in that field.

What is the scripting to do this?

Thank you,

Evan

[nagaiank]

Try the following expression.

Left([Line Item], Len([Line Item])-10)

[maxgro]

=left([Line item], len([Line item]) -10)

[#4]

We don't have direct function to achieve this. We can use below expression.

trim(replace([Line Item],right([Line Item],10),' '))

[oscar_ortiz · Accepted solution]

I like to inculde the Trim function in case there are beginning or trailing blanks:

Left( [Line item], Len( Trim( [Line item]) ) - 10)

[evansabres]

Thank you!

[evansabres]

Thank you!

[evansabres]

Thank you!