topic Re: How to skip last digits in Talend Studio

How to skip last digits

Anonymous — Sat, 16 Nov 2024 03:44:22 GMT

Hi,

I am reading data from the XL file and stored in the Mysql table. for ex: I want to store the ID column values W95343545125 = W9534354512 (How to remove last digits )

Re: How to skip last digits

TRF — Tue, 24 Dec 2019 06:08:41 GMT

StringHandling.LEFT(row1.id, 12)

Re: How to skip last digits

Anonymous — Tue, 24 Dec 2019 06:33:15 GMT

Hi TRF,
Thanks for your reply, but the ID column value length is not fixed, This is a dynamic value. then how to solve this problem,
help me.

Re: How to skip last digits

manodwhb — Tue, 24 Dec 2019 06:50:18 GMT

@Dhandu502 , try the below one.

StringHandling.LEFT(row1.name ,StringHandling.LEN(row1.name)-1)