Start a new topic

Remove Lead Zeros

I need help writing a regular expression to remove lead zeros from constituent IDs.  We have added lead zeros to standardize the length of our IDs for barcode scanning but when I import information back into Raiser's Edge, I need those extra zeros removed.  I found how to add lead zeros but not how to remove... any help would be much appreciated!


Hi Erin,


Value to match on ^0* replacement value -BLANK-


Thanks,


John

Beautiful!  Thanks so much, John!

Hi Erin, there is also a checkbox setting with IOM that can do that as an alternative to the RegEx. 

image


Login or Signup to post a comment