To filter out the non-numerical characters (like the '$' sign) from the string using the RegexReplaceAll action in Mendix, you can use the following:
Needle (Regex): This is the pattern you want to search for and replace.
The regex to match non-digit characters (including the dollar sign '$') would be [^\\d]+.Explanation:[^\\d] matches any character that is not a digit.+ ensures that one or more occurrences of these non-digit characters are matched.
The other option is
Replacement: This specifies what the matched pattern should be replaced with. In this case, you'd replace the non-digit characters with an empty string, effectively removing them.
The replacement string would be an empty string, "".So, in the Mendix RegexReplaceAll action:
Needle (Regex): [^\\d]+Replacement: ""So this configuration will remove any non-digit characters from your string, effectively leaving only the numerical values.
Here as you can see the error that I get: