i'm having trouble Trimming from an account number

[clboehm]

I have an account number that needs the first digit removed and last 2 digits removed.

Account Field--#0015 4030 9#

Needs both # signs removed and the trailing digit, this one being the 9

Need "0015 4030"

I was able to get his done only because the acct # is only 9 digits so I could use the mid string function

 

Mid(str, start, length)

 

var sNameTrim = Mid(Field("ID") ,2 , 9);

return sNameTrim ;

 

 

Thanks

~Chris

 

Mac OS 10.4.11

Acrobat 7.1.0

FusionPro Desktop 5.1P2b