Drag and drop the Talend tMap, and connect the tFileInputDelimited Main row to tMap. GCC, GCCH, DoD - Federal App Makers (FAM). It is very simple to convert String to BigDecimal in java. document.getElementById( "ak_js_1" ).setAttribute( "value", ( new Date() ).getTime() ); Get quality tutorials to your inbox. You may also find it helpful to create a utility method that takes the String to be converted as well as a Decimal value to return if an error occurs. Adding patterns to the analyzed columns in the delimited file. PostgreSQL type cast :: operator Besides the type CASTsyntax, you can use the following syntax to convert a value of one type into another: expression::type Code language:SQL (Structured Query Language)(sql) See the following example: SELECT'100'::INTEGER, I have a list in SharePoint with a string column. OR Integer.valueOf(str).intValue() String Date TalendDate.parseDate("dd-MM-yyyy", str) String BigDecimal new BigDecimal(str) String Float Float.parseFloat(str) OR Float.valueOf(str).floatValue(); String Long . announcement a new site! Al. Dim returnValue As Decimal. Anyway, as I couldn't found the information anywhere, if someone have any doubts related to it, will be easier to find. Use the ToString method with required format as shown below: C# txtDept.Text = emp.DepID.ToString (); txtSalary.Text = emp.salary.ToString ( "N2" ); The question was not clear. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 package org.arpit.java2blog; import java.math.BigDecimal; public class BigDecimalToStringMain {