topic Re: [HELP] convert string to short with empty string value in Talend Studio

[HELP] convert string to short with empty string value

Anonymous — Sat, 16 Nov 2024 13:22:09 GMT

good morning..
i'm using talend open studio.
i have a problem; i have an output of a map maken in this way:
id | name| numID| address that are for same reasons all string

i must convert id and numId in short but in same case the input string is empty so when a try to parse in this way:
short.parseShort(numId)
gives an error if you try to convert becuase you have an empty string.
numId could be an imput like "9" or "500" but in same case "".but this case give me the excepction error parse number.
how i have to do ?
thanks in advance

Re: [HELP] convert string to short with empty string value

alevy — Fri, 02 Jul 2010 01:08:05 GMT

short.parseShort(numID.equals("")?"0":numID)

Re: [HELP] convert string to short with empty string value

Anonymous — Fri, 02 Jul 2010 08:04:21 GMT

no, in this way when the input is "" the output will be 0 but i need to have the same input, nothing, not a number (0)!because then i must insert this number in a db and numID cannot be 0 but can be null or empty. in my case should be empty not 0!

Re: [HELP] convert string to short with empty string value

alevy — Fri, 02 Jul 2010 08:06:36 GMT

I don't believe there's such a thing as an empty short; it's either a number or null.
If you want a null use: numID.equals("")?null:short.parseShort(numID)

Re: [HELP] convert string to short with empty string value

Anonymous — Fri, 02 Jul 2010 10:50:08 GMT

i have tried in this way but gives error
i have written in the map either in this way :
(row3.numId.equals(" ") ? null: Short.parseShort(row3.numId))
either iin this:
(row3.numId.equals("") ? null: Short.parseShort(row3.numId))
but in the first case the error is:
numberFormatException for input string: " "
at java.lang.NumberFormatException.forInputString(Unknown Source)
at java.lang.Integer.parseInt(Unknown Source)
at java.lang.Short.parseShort(Unknown Source)
at java.lang.Short.parseShort(Unknown Source)
at testmdb.testmodelapg_0_1.testModelApg.tAccessInput_1Process(testModelApg.java:4585)
at testmdb.testmodelapg_0_1.testModelApg.runJobInTOS(testModelApg.java:8327)
at testmdb.testmodelapg_0_1.testModelApg.main(testModelApg.java:8201)
in the second case the error is:
java.lang.NullPointerException
at testmdb.testmodelapg_0_1.testModelApg.tAccessInput_1Process(testModelApg.java:4587)
at testmdb.testmodelapg_0_1.testModelApg.runJobInTOS(testModelApg.java:8327)
at testmdb.testmodelapg_0_1.testModelApg.main(testModelApg.java:8201)

Re: [HELP] convert string to short with empty string value

Anonymous — Fri, 02 Jul 2010 11:02:50 GMT

(numID == null || numID.iEmpty())?null:short.parseShort(numID)

Re: [HELP] convert string to short with empty string value

Anonymous — Fri, 02 Jul 2010 11:04:55 GMT

where i put this code? in the t_map?

Re: [HELP] convert string to short with empty string value

Anonymous — Fri, 02 Jul 2010 11:18:21 GMT

i have tried but gives an error yet
java.lang.NumberFormatException: For input string: " "
at java.lang.NumberFormatException.forInputString(Unknown Source)
at java.lang.Integer.parseInt(Unknown Source)
at java.lang.Short.parseShort(Unknown Source)
at java.lang.Short.parseShort(Unknown Source)
at testmdb.testmodelapg_0_1.testModelApg.tAccessInput_1Process(testModelApg.java:4585)
at testmdb.testmodelapg_0_1.testModelApg.runJobInTOS(testModelApg.java:8329)
at testmdb.testmodelapg_0_1.testModelApg.main(testModelApg.java:8203)

Re: [HELP] convert string to short with empty string value

alevy — Sun, 04 Jul 2010 02:12:56 GMT

in the second case the error is:
java.lang.NullPointerException

This error would be because you've defined the field as a non-nullable short rather than a nullable Short.

Re: [HELP] convert string to short with empty string value

Anonymous — Mon, 05 Jul 2010 15:29:22 GMT

Hello chira8,
when you do:
(row3.numId.equals(" ") ? null: Short.parseShort(row3.numId))
either iin this:
(row3.numId.equals("") ? null: Short.parseShort(row3.numId))
and if numId = "" then due to your first condition, numID is not equal to " " and therefore it will try to parseShort() numId = "", hence the error you get.
A condition that you could do is :
if(!row3.numId.equals("") && !row3.numId.equals(" "))
Short.parseShort(row3.numId))
Something around those lines, tell me if it helped!
Remi