Using Replace to remove forbidden chatacters

Hi, I have a bit of logic that doesn’t seem to be working as intended. I’m getting the error “ChannelName doesn’t contain allowed characters, please use the valid values”.

The ChannelName is the combination of case number E.G. “00019732” and Asset Name E.G. “3126 Uluru Rock T.M.” The logic should parse the special characters “.” etc as " " and be allowed. But it seems this is not happening. All the characters are there between /…/ and global is on “g”. Should the space " " be represented differently?

Here is the logic, and as pictured below:
{{substring(00019732 - replace(3126 Uluru Rock T.M.; “/[~#%&*{}+-/\:<>?|'”.]/g”; “”" “”"); 0; 50)}}

Hello,
Your regular expression is perfect. You only need to change the replace character with a specific character of Make syntax.
Please be sure you use the right function syntax using Make’s supported ToolBox OR we can say mapping dialog box.


Check this:


Output:

I’ve only fixed the issue regarding replacing and other functions you’ve used look OK
I hope this helps you.


:bulb:P.S.: Always search first, Check Make Academy. If this is helpful, mark it as a solution :white_check_mark: and :+1:
Need expert help or have questions? Contact or comment below! :point_down:

1 Like