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

[uzix]

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]

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

[ankit7359]

hi @uzix,

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