removing last 5 characters of a value

NathanDorsch · 2022-11-02T13:31:09+00:00

There was an error rendering this rich post.

How can I remove the last 5 characters of a text value in ETL?

Find more posts tagged with

Get the left characters up to the length of the last 5 characters.

LEFT(`Field`, LENGTH(`Field`)-5)

Get the left characters up to the length of the last 5 characters.

LEFT(`Field`, LENGTH(`Field`)-5)