Removing X number of characters starting at begining or end

[Adam]

Eh, probably not the most specific subject line...

But, I've got a number of fields in which I need to do things like remove
the first 4 characters, or remove the last 3.

Such as:

F300006745

Remove first 4 to leave

006745

or remove the last 3 to leave

F3000067

Is there a generic type script I can use to accomplish both of these by
changing a few parameters? Or would it require 2 distinctly seperate ones
for each operation?

Thanks.

[PC Datasheet]

To remove first 4 characters:
Mid([MyField],5,Len([MyField]))

To exclude the last 3 characters:
Mid([MyField],1,Len([MyField])-3))

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"Adam" <ad**@firstmanmedia.com> wrote in message
news:95*******************@204.127.204.17...

Eh, probably not the most specific subject line...

But, I've got a number of fields in which I need to do things like remove
the first 4 characters, or remove the last 3.

Such as:

F300006745

Remove first 4 to leave

006745

or remove the last 3 to leave

F3000067

Is there a generic type script I can use to accomplish both of these by
changing a few parameters? Or would it require 2 distinctly seperate ones
for each operation?

Thanks.

[Trevor Best]

Adam wrote:

Eh, probably not the most specific subject line...

But, I've got a number of fields in which I need to do things like remove
the first 4 characters, or remove the last 3.

Such as:

F300006745

Remove first 4 to leave

006745

or remove the last 3 to leave

F3000067

Is there a generic type script I can use to accomplish both of these by
changing a few parameters? Or would it require 2 distinctly seperate ones
for each operation?

Thanks.

Two distinct are Left() and Right() but you'll probably get away with
just the one, mid()

Remove first 4:
NewString = Right(OldString,Len(OldString)-4)
or
NewString = Mid(OldString,5)

Remove last 4
NewString = Left(OldString,Len(OldString)-4)
or
NewString = Mid(OldString,1,Len(OldString)-4)

--
This sig left intentionally blank

[Adam]

Great!

One more real quick.

How about to remove everything in the string except X number of characters
starting at position Y. For example, to keep only the 3 characters
starting at position 8?

So this:

F1053630203XL1

Becomes

020

Thanks!

no****@nospam.spam (PC Datasheet) wrote in
<tX******************@newsread2.news.atl.earthlink .net>:

To remove first 4 characters:
Mid([MyField],5,Len([MyField]))

To exclude the last 3 characters:
Mid([MyField],1,Len([MyField])-3))

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"Adam" <ad**@firstmanmedia.com> wrote in message
news:95*******************@204.127.204.17...

Eh, probably not the most specific subject line...

But, I've got a number of fields in which I need to do things like
remove the first 4 characters, or remove the last 3.

Such as:

F300006745

Remove first 4 to leave

006745

or remove the last 3 to leave

F3000067

Is there a generic type script I can use to accomplish both of these
by changing a few parameters? Or would it require 2 distinctly
seperate ones for each operation?

Thanks.

[Adam]

Ooops, never mind:

Mid([fieldname],8,3)

ad**@firstmanmedia.com (Adam) wrote in
<95*******************@204.127.199.17>:

Great!

One more real quick.

How about to remove everything in the string except X number of
characters starting at position Y. For example, to keep only the 3
characters starting at position 8?

So this:

F1053630203XL1

Becomes

020

Thanks!

F3000067

Is there a generic type script I can use to accomplish both of these
by changing a few parameters? Or would it require 2 distinctly
seperate ones for each operation?

Thanks.