# Remove comma from numeric value

**URL:** <https://connective.celigo.com/t/remove-comma-from-numeric-value/1077>\
**Category:** Integrator.io\
**Tags:** 3pl-central, transformation, mapper, netsuite\
**Created:** [July 30, 2021, 7:20pm UTC](https://connective.celigo.com/t/remove-comma-from-numeric-value/1077 "2021-07-30T19:20:44Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![coryanderson215](https://avatars.discourse-cdn.com/v4/letter/c/c2a13f/32.png) [@coryanderson215](https://connective.celigo.com/u/coryanderson215)\
**Post date:** [July 30, 2021, 7:20pm UTC](https://connective.celigo.com/t/remove-comma-from-numeric-value/1077/1 "2021-07-30T19:20:44Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![davidgollom](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/davidgollom/32/6605_2.png) [@davidgollom](https://connective.celigo.com/u/davidgollom)\
**Post date:** [August 2, 2021, 6:13pm UTC](https://connective.celigo.com/t/remove-comma-from-numeric-value/1077/2 "2021-08-02T18:13:41Z")

</div>

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

[Handlebars helper reference – Celigo Help Center](https://docs.celigo.com/hc/en-us/articles/360039326071-Handlebars-Library#replace)

---

<div class="post-metadata">

**Author:** ![coryanderson215](https://avatars.discourse-cdn.com/v4/letter/c/c2a13f/32.png) [@coryanderson215](https://connective.celigo.com/u/coryanderson215)\
**Post date:** [August 5, 2021, 3:42pm UTC](https://connective.celigo.com/t/remove-comma-from-numeric-value/1077/3 "2021-08-05T15:42:50Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![coryanderson215](https://avatars.discourse-cdn.com/v4/letter/c/c2a13f/32.png) [@coryanderson215](https://connective.celigo.com/u/coryanderson215)\
**Post date:** [August 6, 2021, 5:32pm UTC](https://connective.celigo.com/t/remove-comma-from-numeric-value/1077/4 "2021-08-06T17:32:51Z")

</div>

Update: I did this {{replace Gross\_Weight "," ""}} and it worked perfectly!

---

<div class="post-metadata">

**Author:** ![davidgollom](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/davidgollom/32/6605_2.png) [@davidgollom](https://connective.celigo.com/u/davidgollom)\
**Post date:** [August 6, 2021, 5:34pm UTC](https://connective.celigo.com/t/remove-comma-from-numeric-value/1077/5 "2021-08-06T17:34:39Z")

</div>

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