topic Re: Trimming leading zeroes in Talend Studio

Trimming leading zeroes

Anonymous — Sat, 16 Nov 2024 04:12:23 GMT

How to get a decimal from a string after trimming of leading zeros and non-numeric characters.

Anonymous — Thu, 31 Oct 2019 14:41:22 GMT

Can you give a typical example of the String you want to change?

Anonymous — Fri, 01 Nov 2019 06:28:00 GMT

Let the string be like

000AB1234

001234AB

I need the output as

1234

akumar2301 — Fri, 01 Nov 2019 07:18:42 GMT

Integer.parseInt(text.replaceAll("[^0-9]", ""))

Anonymous — Mon, 04 Nov 2019 05:21:45 GMT

I tried Integer.parseInt(input.replaceAll("[^0-9]", "")) in tjavarow

But I'm getting null in my output

manodwhb — Mon, 04 Nov 2019 05:57:57 GMT

@Matthew , below one should also work.

Integer.parseInt(row1.col1.replaceAll("[^\\d.]", ""))