Length 1

[nickotine]

I have a field which I need to remove the last 2 characters from. I.E. 123h456789d-C1#* this needs to read 123h456789d-c1

I have tried Trim and Left to no avail.

Help Please.

Nickotine.

 

[dhulbert]

Try something along the lines of

left(fieldname,length(fieldname)-2)

 

[nickotine]

Hi thanks for the reply, I did forget to mention that the field i need to remove the last 2 characters is a varable length.

 

[dhulbert]

That will still work. you just nee dot do something to avoid 0,1 or 2 character fields such as
if length(fieldname) > 2 then code here

 

[nickotine]

Thanks for the help finally got it to work.

Cheers,

Nickotine.