Removing last 7 characters

[Anonymous]

Hi

I am trying to remove last 7 characters from a string but my expression does not work , can someone take look at it

Thanks

[sunny_talwar]

Usually something like this should work:

Left(FieldName, Len(FieldName) - 7))

[sunny_talwar · Accepted solution]

Try this:

Left(SummaryTargets.key, Len(Trim(SummaryTargets.key)) - 7)