Need to remove last two bytes of a column values

[Anonymous]

Hi All,

My current extract from Oracle is returning First name concatenated with 1 byte space and 1 byet char. Thus, I am looking forward to truncate the last two bytes of a particular column. Please let me know how can we achieve this.

Current Data :

First Name = "Naveen K"

Expected Data

First Name = "Naveen"

[akumar2301]

Try this
StringHandling.LEFT(mysource.myfield,(StringHandling.LEN(mysource.myfield)-2))