topic Re: receive string value and convert to bigdecimal to be inserted in db as NUMBER(16,2) in Talend Studio

receive string value and convert to bigdecimal to be inserted in db as NUMBER(16,2)

uzix — Mon, 26 Nov 2018 13:08:15 GMT

hi all,

hi have a question.

i receive this value as string :

1,000.36

and i must insert it in a db as NUMBER(16,2)

respecting the format:

#,###.##

before inserting in db.

what is the best way?

thank you very much!!!

Anonymous — Mon, 26 Nov 2018 13:40:02 GMT

The tMap component has BigDecimal as one of the available formats. You could use that along with the convertImpliedDecimalFormat() function.

ankit7359 — Mon, 26 Nov 2018 14:52:35 GMT

Greetings of the day,

Well, always remember you can cast your data-type.

So to cast from String to Integer. you can either use a Tmap or tconverttype components.

Tconverttype - you can auto-cast your data-types as per your schema specifications.

Tmap - you can change your data-type from one to another.

you can use this method to convert string to Integer -> Integer.parseInt(row1.columnname).

Pls reach out to the community if necessary.

Thanks,

Ankit