removing last 5 characters of a value

Options
NathanDorsch
NathanDorsch Member
in Magic ETL

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

Best Answer

  • GrantSmith
    GrantSmith Coach
    Answer ✓

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

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


    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Answers

  • GrantSmith
    GrantSmith Coach
    Answer ✓

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

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


    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Categories