topic Convert Integer to String in Talend Studio

Convert Integer to String

Anonymous — Sat, 16 Nov 2024 14:25:32 GMT

I need to convert a primary key Interger to a String.
In the tMap I have written: (REF.REF_ID).toString() but the following error appears: "cannot invoke toString() on the primitive type int".
How can I convert it?
Thanks

Re: Convert Integer to String

olektrolek — Wed, 19 Mar 2008 15:26:10 GMT

try:
(new Integer(yourvalue)).toString()
hope this helps

Re: Convert Integer to String

Anonymous — Wed, 19 Mar 2008 15:34:17 GMT

Or you can use ""+REF.REF_ID

Re: Convert Integer to String

Anonymous — Wed, 19 Mar 2008 18:06:13 GMT

I see the "Perl" tag associated to this topic, but I don't think you're using a Perl project as Perl do this kind of conversion automatically. Can you confirm you're using Java?

Re: Convert Integer to String

Anonymous — Fri, 21 Mar 2008 07:55:04 GMT

Excuse me for the wrong information: my project is in java!
The solution (new Integer(REF.REF_ID)).toString() seems to work.
I had tried the: ""+REF.REF_ID without success!!
Thanks to every body.

Re: Convert Integer to String

Anonymous — Fri, 21 Mar 2008 08:05:40 GMT

I have replied to quick.
With the expression (new Integer(REF.REF_ID)).toString() the tMap expression builder don't make an error anymore. But the tMap component falls in error. The convertion of interger to string for a primary key is not possible.

Re: Convert Integer to String

Anonymous — Fri, 21 Mar 2008 08:14:31 GMT

Hi
Try this:
String.valueOf(REF.REF_ID)
Best regards
shong

Re: Convert Integer to String

Anonymous — Mon, 17 Jan 2011 16:25:44 GMT

hi Shong, I am facing similar issue (converting string to char). My input schema is string/char and output schema is char column from OracleSP. It says datatype/argument mismatch when I run the job. Pls suggest.

Re: Convert Integer to String

ashok5 — Tue, 05 Aug 2014 17:57:27 GMT

Hi Pratik
you can use tconvertType component for converting column of one data type to other data type in talend
Regards
Ashok

Re: Convert Integer to String

janhess — Thu, 07 Aug 2014 10:03:38 GMT

or you can Google it to find all the java conversions

Re: Convert Integer to String

Anonymous — Fri, 23 Mar 2018 20:25:01 GMT

I'm new to Talend. what do you mean by REF.REF_ID. Would you provide an example. Also there is a DataOperation Function called CHAR(int I):id_Character - DataOperation which converts a numeric value to its ASCII character string equivalent. Does this accomplish the same thing?

Re: Convert Integer to String

Anonymous — Fri, 23 Mar 2018 20:26:45 GMT

BTW, the CHAR function is listed in tMAP if using the Expression Builder.