topic Re: How to use StringHandling.LEN() function for integer column? in Talend Studio

How to use StringHandling.LEN() function for integer column?

RAJ6 — Sat, 16 Nov 2024 09:26:18 GMT

Hi Talend Folks,

I want know how to use StringHandling.LEN() function for integer column. I am facing error in below query. could please tell me?

StringHandling.LEN(row1.CARID)>2?0:1

Re: How to use StringHandling.LEN() function for integer column?

cterenzi — Mon, 07 Aug 2017 13:34:17 GMT

StringHandling functions are for strings. What exactly are you trying to do?

Re: How to use StringHandling.LEN() function for integer column?

RAJ6 — Mon, 07 Aug 2017 14:04:33 GMT

Dear cterenzi,

THANK YOU FOR IMMEDIATE RESPONSE

HOW TO FIND COLUMN VALUE LENGTH?

FOR EXAMPLE:

IF CARID Column VALUE LENGTH IS GREATER THAN 2 I NEED TO SET 0 ELSE I NEED TO SET 1

LEN(ROW1.CARID)>2 ? 0 : 1

Re: How to use StringHandling.LEN() function for integer column?

TRF — Mon, 07 Aug 2017 14:33:49 GMT

Asking for Integer length doesn't make sense.
If ROW1.CARID is Integer datatype use this:
ROW1.CARID > 99 ? 0 : 1
If it's > 99, the length is > 2, isn't it?

Re: How to use StringHandling.LEN() function for integer column?

javvaji — Mon, 07 Aug 2017 16:18:38 GMT

Hi RAJESH_GJ,

Try to convert the integer value to string and use the length function.

Below is the function.

StringHandling.LEN(row1.newColumn.toString())

Thanks,

Bharath.

Re: How to use StringHandling.LEN() function for integer column?

TRF — Mon, 07 Aug 2017 17:56:07 GMT

A little expensive just to know if an Integer is greater to 99.
Doesn't it?