Trimming a variable number of characters from field...

[Mitch_____W]

I need to cut the first 3 characters from each record in a field. each record has a total amount of characters. I tried using a combination of the Right() and Len() functions with no luck...

EX:
=Right([Serial_Number],((Len([Serial_Number])-3))

Any Ideas???

Thanks in advance!!!

Mitch

 

[pcs]

i may be missing something here...

but have you tried:

Mid([YourField],4,Len([YourField]))


hth,
al

 

[Mitch_____W]

Let me just say that......YOU ROCK!!!!!!!

That works stupendously!!

Mid([YourField],4,Len([YourField]))

The only thing I changed was the LEN() to a number which is greater than any entry in that field will ever be because the MID() would not accept the LEN() as the 3rd argument:

Mid([YourField],4,51)

THANK YOU VERY MUCH PCS!!!

Mitch

 

[SteveA]

The length parameter for the MID function is optional. If you leave it blank, MID will return everything from parameter 2 onwards ie MID("Hello World",4) will return "lo World"

Cheers,
SteveA

 

[pcs]

you are right steve...my error.

been hammering out too much Unibasic code this week...my syntax has gotten confused

al