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
🌐
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
🌐
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
🌐
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
🌐
GitHub
gist.github.com › sjantke › ce8779277d5d44baf46a8a9a1151881b
Talend/Java: Convert Input Strings to Boolean, BigDecimal and Integer · GitHub
Talend/Java: Convert Input Strings to Boolean, BigDecimal and Integer · Raw · TypeConvertUtil.java · This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
🌐
Talend
community.talend.com › s › question › 0D53p00007vClLlCAK › resolved-string-to-bigdecimal-conversion
Home | Qlik Community
MillerKnoll partnered with Qlik Talend® data solutions to unify data across its diverse systems, accelerating critical processes and nearly eliminating data integration issues organization-wide.
🌐
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.