Hi Guys
Sorry for this being a short post, but I am pushed for time. The problem I have is I have data in a field as follows
“CCSE123456” and I need to be able to run a procedure to remove the leading 4 characters, i.e. “CCSE”. The problem is I can remember how to do this. LTRIM is no good as these are not blanks or leading spaces and when I tried to use StrDel I was told it wouldn’t compile. I know it can be done, but would appreciated a little nudge in the right direction.
Thanks in advance
Wideawake
Sorry for this being a short post, but I am pushed for time. The problem I have is I have data in a field as follows
“CCSE123456” and I need to be able to run a procedure to remove the leading 4 characters, i.e. “CCSE”. The problem is I can remember how to do this. LTRIM is no good as these are not blanks or leading spaces and when I tried to use StrDel I was told it wouldn’t compile. I know it can be done, but would appreciated a little nudge in the right direction.
Thanks in advance
Wideawake