https://community.qlik.com/t5/Talend-Studio/negative-number-surrounded-by-parenthesis/m-p/2338449#M106679 I think you've taken the correct approach by writing a custom routine to perform the conversion. Wed, 24 Jul 2013 08:43:45 GMT Anonymous 2013-07-24T08:43:45Z https://community.qlik.com/t5/Talend-Studio/negative-number-surrounded-by-parenthesis/m-p/2338448#M106678 Hi All, <BR />I would like to know if there's a way for talend by default import as negative number what comes surrounded in parenthesis? <BR />For instance, a file containing a columns as statement with some positive and negatives numbers (round brackets) <BR />ie <BR />Statement <BR />(404) <BR />(500) <BR />(1200) <BR />3200 <BR />If use this file to get the schema, this column will be recognized as STRING not as INTEGER/DOUBLE/FLOAT and if it's needed to make calculations, like sum, avg, etc Talend raise errors (NumberFormatException), due all values surrounded by parenthesis not be converted by negative numbers (ie. (404) = -404). <BR />I did a trick into my job, creating a routine to convert round brackets negative numbers to numbers with minus sign, but would I to know if there is a way for Talend to do that by default? <BR /> <BR />Thnanks in Advanced, <BR /> <BR />Rodrigo A. Gomes Wed, 24 Jul 2013 02:36:26 GMT https://community.qlik.com/t5/Talend-Studio/negative-number-surrounded-by-parenthesis/m-p/2338448#M106678 Anonymous 2013-07-24T02:36:26Z https://community.qlik.com/t5/Talend-Studio/negative-number-surrounded-by-parenthesis/m-p/2338449#M106679 I think you've taken the correct approach by writing a custom routine to perform the conversion. Wed, 24 Jul 2013 08:43:45 GMT https://community.qlik.com/t5/Talend-Studio/negative-number-surrounded-by-parenthesis/m-p/2338449#M106679 Anonymous 2013-07-24T08:43:45Z