This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

I've tried multiple ways to replace characters in my string but neither works in my formula. Any ideas? Should be a simple thing

<http://www.netsuiterp.com/2018/11/using-replace-and-substr-for-formula.html>

Tried that as well but that doesn't seem to work either. Also the REPLACE function in workflows shows it should be in the format `str.replace(regexp, str)`

ah yes, if this wf action is type of client trigger then you must use SuiteScript 1.0 API functions. And my previous post is valid only for server type triggers.

and I'm not familiar with SuiteScript but it seems that you must user lowercase for this function name: .replace(xxxx)
Update: yep, it works, just tried  {firstname}.replace('-','_')

I was already afraid that it would be something that small. I'm gonna try

My final working solution `{custitem_item_isbn_number}.replace(/-/g,'')`

couldn't you have done `REPLACE({fieldid}, '-','_')`?