Remove comma from numeric value

Integrator.io
, , ,
1

Mapping fields from a 3PL to NetSuite. I need to remove the comma from numeric string such as "1,234.00". The result I'm looking for would just be "1234.00". I suspect that a regexReplace function could do this, but I have not done regex expressions. Any help would be appreciated.

2

There's also a standard "replace" expression that's simpler to use.

Handlebars helper reference – Celigo Help Center

3

Thanks, David. I'll give that a shot. Not sure how I missed that one! 😁

4

Update: I did this {{replace Gross_Weight "," ""}} and it worked perfectly!

5

Cool! some of the data type conversions might have helped too, but the comma replacement seemed simple.