In regex syntax, "$" indicates the end of the string. In your regex, you are trying to remove any character after the end of the string which is not a number or a dot, which won't work, so the "," is never removed from your string, resulting in a conversion error.
You can do this:

new BigDecimal(row1.Trade_Amount.replaceAll("[^\\d.]", ""))
Answer from Ibrahim Mezouar on Stack Overflow
🌐
Stack Overflow
stackoverflow.com › questions › 74689534 › convert-string-to-big-decimal
talend - Convert String to Big Decimal - Stack Overflow
I have a value (surv_amount) which is currently a string within the database. I need to convert it from a string to a big decimal in TMap. I have tried new BigDecimal(surv_amount) but get this error message: java.lang.NullPointerException: Cannot invoke "String.equals(Object)" because "schema_talendStats_DB" is null
🌐
YouTube
youtube.com › vlogize
How to Convert a String to BigDecimal in Talend TMap - YouTube
Learn how to easily convert a string value to BigDecimal in Talend TMap with step-by-step guidance to resolve common errors.---This video is based on the que...
Published   March 25, 2025
Views   2
🌐
Qlik Community
community.qlik.com › t5 › Talend-Studio › Converting-a-string-to-BigDecimal › td-p › 2275047
Solved: Converting a string to BigDecimal - Qlik Community - 2275047
November 16, 2024 - receive string value and convert to bigdecimal to be inserted in db as NUMBER(16,2) Tags · talend · studio · Talend Studio · api · java · etl · json · Talend Data Integration · tmap · xml · excel · rest · snowflake · zip · archive · child · component · configuration ·
🌐
DZone
dzone.com › culture and methodologies › career development › handling bigdecimal in talend
Handling BigDecimal in Talend - DZone
January 29, 2018 - First, we go with a BigDecimal value such as 1.8772265500517E19. It means 1.8772265500517 x 1019 . We need to pass it without scientific notation. You can use a tJava comment in Talend and use simple Java to achieve this.
🌐
Qlik Community
community.qlik.com › t5 › Talend-Studio › Convert-a-string-to-Big-Decimal › td-p › 2348714
Solved: Convert a string to Big Decimal - Qlik Community - 2348714
November 15, 2024 - We start by initializing a string variable `str` with the value "$6.00". We then create a `BigDecimal` object `bd` by passing the string `str` to the constructor of `BigDecimal`.
Find elsewhere
🌐
O'Reilly
oreilly.com › library › view › talend-open-studio › 9781782167266 › apa.html
A. Common Type Conversions - Talend Open Studio Cookbook [Book]
October 25, 2013 - Appendix A. Common Type ConversionsThe following table is a set of Java and Talend methods that allow conversion between different data types. This is by no means an... - Selection from Talend Open Studio Cookbook [Book]
Author   Rick Barton
Published   2013
Pages   270
🌐
Talend
community.talend.com › t5 › Design-and-Development › How-to-convert-String-to-Bigdecimal › td-p › 23938
Home | Qlik Community
November 5, 2017 - "If you have the zip file of the custom Hadoop distribution you need to connect to, select Import from zip. Talend community provides this kind of zip files that you can download from http://www.talendforge.org/exchange/index.php.", the documentation states.
🌐
Blogger
madhukaudantha.blogspot.com › 2018 › 01 › handling-bigdecimal-in-talend.html
Madhuka: Handling BigDecimal in Talend
Post is very basic one, Since Talend is all about data integration. Finding a BigDecimal [1] in such data set is very common. BigDecimal VS ...
🌐
Rip Tutorial
riptutorial.com › table of conversions
talend Tutorial => Table of Conversions
╔══════════... Integer.parseInt(str) OR Integer.valueOf(str).intValue() ║ ║String ║ Date ║ TalendDate.parseDate("dd-MM-yyyy", str) ║ ║String ║ BigDecimal ║ new BigDecimal(str) ║ ║String ║ Float ║ ...
🌐
Qlik Community
community.qlik.com › t5 › Talend-Studio › Error-converting-string-to-bigdecimal-on-tMap › td-p › 2298377
Solved: Error converting string to bigdecimal on tMap - Qlik Community - 2298377
March 6, 2018 - If a String representation of a number is empty ("") or has an extra space (" 34.8") or even has thousand separators ("10,000.00"), this error will be thrown. The first thing to try is to retrieve your data from the file in correct format. You should be able to adjust your schema for the file to set what it picks up as a BigDecimal.