Need to remove last two bytes of a column values

Highlighted
Five Stars

Need to remove last two bytes of a column values

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"

Highlighted
Eleven Stars

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


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

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 3

Read about some useful Context Variable ideas

Blog