Excel Formulas in Fields

[red2002yzfr1]

Does anyone know how (or is it possible) to use Excel formulas in AutoCAD fields. What I am trying to do is this, my drawing filenames have a revision number at the the end of the filename. What I would like to be able to do is something similar to the "right" formula in excel, return the last 2 number/characters in the filename, so I may use this in my revision area of my title block.

Thanks for any help!

[RobertB]

Fields support DIESEL expressions, so you ought to be able to do it.

[red2002yzfr1]

Thanks for your help RobertB. I did use a DIESEL expression and after figuring it out, (nothing was working until I embedded the expressions), it worked great, thanks again.


Just FYI, heres what I did:

$(UPPER,$(SUBSTR,$(getvar,dwgname),1,12))

This codes result is the drawing name, in UPPERCASE, but only the first 12 num_char. If you want another result, change the numbers at the end, play with it, you'll figure it out.

$(UPPER,$(SUBSTR,$(getvar,dwgname),14,2))

This codes result is the drawing name, in UPPERCASE, starting at the 14th num_char and only 2 num_char.