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
There's also a standard "replace" expression that's simpler to use.
Handlebars helper reference – Celigo Help Center
Thanks, David. I'll give that a shot. Not sure how I missed that one! 😁
Update: I did this {{replace Gross_Weight "," ""}} and it worked perfectly!
Cool! some of the data type conversions might have helped too, but the comma replacement seemed simple.
Please sign in to leave a comment.