topic Re: Convert string to integer or float in Talend Studio

Convert string to integer or float

Anonymous — Sat, 16 Nov 2024 14:21:14 GMT

Hi,
Do you Know an instruction to transform a string to an integer or a float in Tmap?
Thanks

Re: Convert string to integer or float

Anonymous — Wed, 28 May 2008 16:52:24 GMT

Hello
You can try Integer.parseInt("10") or Float.parseFloat("10.0")
Regards,

Re: Convert string to integer or float

Anonymous — Thu, 29 May 2008 10:12:47 GMT

Hi mhirt,
With Float.parseFloat(?10.0?), I have the following message
Expression of Var.var1 is invalid : Error on Float.parseFloat(?10.0?) => Type mismatch : cannot convert from float to String
Thanks

Re: Convert string to integer or float

amaumont — Thu, 29 May 2008 10:23:12 GMT

Change the type of your column Var.var1 from "String" type to "float" or "Float" type and it should work 🙂

Re: Convert string to integer or float

Anonymous — Fri, 30 May 2008 08:23:18 GMT

Thanks amaumont

Re: Convert string to integer or float

Anonymous — Fri, 30 May 2008 10:45:55 GMT

Hi,
Do you Know an instruction to transform a Float or integer to a String in Tmap?
Thanks

Re: Convert string to integer or float

amaumont — Fri, 30 May 2008 10:54:46 GMT

This is:

String.valueOf(yourValue)

"" + yourValue

Re: Convert string to integer or float

Anonymous — Fri, 30 May 2008 14:45:53 GMT

Thanks amaumont

Re: Convert string to integer or float

Anonymous — Wed, 25 Nov 2009 17:56:44 GMT

Hi all,
I have a HOME PHONE NUMBER as a STRING that I want to only get the first 3 digits (AREACODE) of and then want to convert to an INT..
Right now im using the following and getting an error:
I create a variable as so...
StringHandling.LEFT(row1.homePhoneNum,3) which is called VAR.SDHAREA(STRING)
THEN...
I map it to my output and try to convert it to an int as follows...
Integer.parseInteger(VAR.SDHAREA)

Anyone have any ideas on how to accomplish this?
Any help would be greatly appreciated!
-Chris

Re: Convert string to integer or float

Anonymous — Thu, 26 Nov 2009 08:52:00 GMT

Hi chrish:
JDK API ( http://java.sun.com/j2se/1.5.0/docs/api/) :
Class: java.lang.Integer
static int parseInt(String s)
Parses the string argument as a signed decimal integer.
you should try Integer.parseInt(VAR.SDHAREA)

Re: Convert string to integer or float

Anonymous — Wed, 20 Jan 2010 11:38:40 GMT

Have a problem... try to convert string to int like this "5 600" from xls file. shows error
xception in component tMap_1
java.lang.NumberFormatException: For input string: "5 250"
at java.lang.NumberFormatException.forInputString(Unknown Source)
try to do like this
row1.Hotel_commissions.toString().equals("#") || row1.Hotel_commissions.toString().equals("") ? null :
Integer.parseInt(row1.Hotel_commissions.toString().replace(" ",""))
this not help

Re: Convert string to integer or float

Anonymous — Thu, 21 Jan 2010 23:53:30 GMT

ug. Java's not the best for string manipulation. in perl the correct solution would be:
my $input = "5 250"
my $output = do { $input =~ s/\s//g; };

I highly suggest checking out the Perl version of Talend. Perl was built for ETL and Talend makes writing powerful ETL scripts very fast.

Re: Convert string to integer or float

Anonymous — Fri, 22 Jan 2010 13:29:58 GMT

this is right if you want to drop.
Right conversion is made with Math.rint() or Math.round().or you can do it by hand:
float f = 234.33;
int i = (int)(f + 0.5f);
i has value 234
float f = 234.57;
int i = (int)(f + 0.5f);
i has value 235;

Re: Convert string to integer or float

baskarchennai — Wed, 29 Feb 2012 15:14:39 GMT

Hi,
I want to parse a string and change the format as given below,
Input : C0003129872
Outpput : C=3129872
Could anyone tell me how can this be obtained pls?

Re: Convert string to integer or float

Anonymous — Thu, 01 Mar 2012 08:42:40 GMT

Hi baskarchennai,
You can do it by using this code:

StringHandling.CHANGE("C0003129872", "000", "=")

Regards,
Khor.

Re: Convert string to integer or float

slim025 — Mon, 12 Aug 2013 13:32:46 GMT

Hello,
I would like to know how I do in Talend to calculate the age of a person from his date of birth?
I know we need to use the current date, but I look for the syntax.
Thank you in advance

Re: Convert string to integer or float

alevy — Tue, 13 Aug 2013 02:52:40 GMT

Don't post the same question more than once - https://community.talend.com/t5/Design-and-Development/Calculate-the-age-from-the-current-date-and-the-date-of-birth/td-p/116052.

Re: Convert string to integer or float

_AnonymousUser — Tue, 02 Jun 2015 07:44:31 GMT

More about......String to Integer
Biden

Re: Convert string to integer or float

nar — Tue, 01 May 2018 22:12:55 GMT

i want to convert from float to double. i used this, "row1.doubleValue() " . now i'm facing null point exception error. Any suggestions.

Re: Convert string to integer or float

manodwhb — Wed, 02 May 2018 05:38:17 GMT

@nareshm, you are getting null as part of data,so before converting to double handle nulls like this .

row1.Value==null ? row1.Value.doubleValue() : row1.Value