Remove text from string

[MadMax7]

Hello all

I need to remove the first 2 characters and the last 4 characters from a string can some tell me the best way to do this please

 

[jebry]

Hi!

NewString = Mid(OldString, 3 , Len(OldString) - 6)

hth


Jeff Bridgham
bridgham@purdue.edu

 

[fredericofonseca]

If doing a SQL to retrieve the data you may need to do it differently, and that will depend on the Database you are using.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com