Removing last 3 characters

SSIS and Import/Export
1

How do I remove the last three characters in the string using a derived column?

2

SELECT column, STUFF(column, LEN(column) - 2, 3, '') AS derived_column

3

thanks,

They probably didn't explain it right. I can't use any SQL. I have to use ssis logic if possible. is there a way of doing it without using sql

4

Hopefully someone else can provide that, I am more a SQL person.

5

Use as expression of your derived column:
left([MyFieldName],len(MyFieldName]-3)

6

No problem thanks

7

I keep getting an error on this. I have changed the brackets as well to this

left([MyFieldName],len[MyFieldName]-3)

Any idea why it would get erros. Also chnaged rhe name of the columns to my column names

8

LEFT and LEN are functions so they need ().

=left([MyFieldName],len([MyFieldName])-3)

9

that worked thanks