How to skip last digits

[Anonymous]

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 )

[TRF]

StringHandling.LEFT(row1.id, 12)

[Anonymous]

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.

[manodwhb · Accepted solution]

@Dhandu502 , try the below one.

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