D
DrEvil
Hi,
I have about 22000 cases in database which I would like to reformat. The
case numbers look like this ###-####### , what I would like to do is only
remove first 3 digits after a dash and leave the rest so the format would
look like this ###-#### , the first 3 digits after dash are always zeros (not
sure if that makes any difference). The field is formated as text.
I have about 22000 cases in database which I would like to reformat. The
case numbers look like this ###-####### , what I would like to do is only
remove first 3 digits after a dash and leave the rest so the format would
look like this ###-#### , the first 3 digits after dash are always zeros (not
sure if that makes any difference). The field is formated as text.