Remove comma from numeric value

Cory Anderson

• July 30, 2021 19:20

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

• 

  David Gollom Channel Partner

  • August 02, 2021 18:13

  

  

  

  

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

  Handlebars helper reference – Celigo Help Center

   

  0
• 

  Cory Anderson

  • August 05, 2021 15:42

  

  

  

  

  

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

  0
• 

  Cory Anderson

  • August 06, 2021 17:32

  

  

  

  

  

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

  1
• 

  David Gollom Channel Partner

  • August 06, 2021 17:34

  

  

  

  

  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.