https://community.qlik.com/t5/Talend-Studio/Convert-String-to-BigDecimal/m-p/2369015#M132207 Hi, <BR />I have a problem writing an expression in tMap. I want to convert a field which is a String to a field which is BigDecimal. &nbsp;I also need to check the content of String field - if it has "szt" then I need to send 1 and if not then I need to send the value of the field (converted to BigDecimal). <BR />Thanks for all the suggestions because I'm stuck <span class="lia-unicode-emoji" title=":confused_face:">😕</span> Thu, 16 Jun 2016 11:32:02 GMT Anonymous 2016-06-16T11:32:02Z https://community.qlik.com/t5/Talend-Studio/Convert-String-to-BigDecimal/m-p/2369015#M132207 Hi, <BR />I have a problem writing an expression in tMap. I want to convert a field which is a String to a field which is BigDecimal. &nbsp;I also need to check the content of String field - if it has "szt" then I need to send 1 and if not then I need to send the value of the field (converted to BigDecimal). <BR />Thanks for all the suggestions because I'm stuck <span class="lia-unicode-emoji" title=":confused_face:">😕</span> Thu, 16 Jun 2016 11:32:02 GMT https://community.qlik.com/t5/Talend-Studio/Convert-String-to-BigDecimal/m-p/2369015#M132207 Anonymous 2016-06-16T11:32:02Z https://community.qlik.com/t5/Talend-Studio/Convert-String-to-BigDecimal/m-p/2369016#M132208 str == null ? null : (str.contains("szt") ?&nbsp;new BigDecimal(1) :&nbsp;new BigDecimal(str))<BR />Lin LIN<BR />Consultant BI/Talend<BR />Synaltic Group Thu, 16 Jun 2016 14:40:06 GMT https://community.qlik.com/t5/Talend-Studio/Convert-String-to-BigDecimal/m-p/2369016#M132208 Anonymous 2016-06-16T14:40:06Z