Remove comma from numeric value

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. 

0

Comments

4 comments
Date Votes
  • Update:  I did this {{replace Gross_Weight "," ""}} and it worked perfectly!

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

    Handlebars helper reference – Celigo Help Center

     

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

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

    0

Please sign in to leave a comment.

 

Didn't find what you were looking for?

New post