I have an incoming gift amount field that is formatted as currency (i.e. $5.00, or $10.50). I need a dictionary that strips it to just 5.00 or 10.50. It seems very simple to remove the $, but it just isn't working for me this morning.
I need to strip the $ because I'm using API to look for gifts greater than $5 to setup different acknowledgement and letter codes and it gives me an error that the incoming data is in the wrong format.
Since dollar sign is a metacharacter in RegEx you need to escape it with a backslash. Value to match on \$ replacement value blank with RegEx turned on.
Thanks,
John
B
Barbara Daenzer
said
almost 5 years ago
Thank you!
J
John Shephard
said
almost 5 years ago
As a side note since you are doing this through the API you could remove the dollar sign in code like this
Barbara Daenzer
I have an incoming gift amount field that is formatted as currency (i.e. $5.00, or $10.50). I need a dictionary that strips it to just 5.00 or 10.50. It seems very simple to remove the $, but it just isn't working for me this morning.
I need to strip the $ because I'm using API to look for gifts greater than $5 to setup different acknowledgement and letter codes and it gives me an error that the incoming data is in the wrong format.