Jump to content

Trimming from an account number


clboehm

Recommended Posts

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

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...