I’m not very good at regex. Is there a way to get rid of the $
in ‘$100.00’ in SQL?
Hello,
One way to do this would be to use the REGEXP_REPLACE
function described here: String Functions | Rockset Documentation
In your case you can try this:
REGEXP_REPLACE('$100.00', '^\$');
I hope this helps. Let us know if you have any other questions.
1 Like