Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I like to inculde the Trim function in case there are beginning or trailing blanks:
Left( [Line item], Len( Trim( [Line item]) ) - 10)
Try the following expression.
Left([Line Item], Len([Line Item])-10)
=left([Line item], len([Line item]) -10)
We don't have direct function to achieve this. We can use below expression.
trim(replace([Line Item],right([Line Item],10),' '))
I like to inculde the Trim function in case there are beginning or trailing blanks:
Left( [Line item], Len( Trim( [Line item]) ) - 10)
Thank you!
Thank you!
Thank you!