Need to remove last two bytes of a column values

Anonymous — Sat, 16 Nov 2024 03:28:50 GMT

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"

Re: Need to remove last two bytes of a column values

akumar2301 — Sat, 25 Jan 2020 17:07:56 GMT

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

topic Need to remove last two bytes of a column values in Data Quality

Need to remove last two bytes of a column values

Re: Need to remove last two bytes of a column values