Solved! Go to Solution.
Hi Kevin,
I see that Tom gave you an easy solution and I agree that using REPLACE in this case is easier.
I have made an example by using REGEX tool to answer in your question.
At the REGEX tool chose in which field you want to replace the character, in this case "Gross Rate", at Regular Expression set $ - use back slash in front of dollar $ because if you leave just $ then the Regex will not replace $ because it's the special Characters which Regex is using. At the Output Method chose Replace and in the Replacement Text you can replace to whatever you want but in your case you want to replace $ with nothing so leave it empty.
Hope you will find this as helpful.
Good Luck
Dest
For this, you can simply use the formula tool with this expression :
Trim([GROSS RATE],"$") - This removes "$" from beginning and end of the string.
> First, trim the field and the convert the string to double. This results in what you are expecting.
> If you convert to double and then trim the field - You will get null or 0 for the values with "$".
I hope you will find this information useful.