Truncate the 3 leftmost characters

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a column named Seat # which contains the following:

PL1 O-302 P-606 P-605 P-604 P-603 P-602 P-601

I need to get rid of the first three digits (PL1)

I am using MS Windows 2000

Thank you,
 
Right([Seat #], Len([Seat #])-3)

This removes the left 3 characters but in your data example you will then
have a leading space.

In looking at your data example it seems your table is not design correctly
in that you are listing a string of seat numbers in the same text field
instead of separately.
 
I have a column named Seat # which contains the following:

PL1 O-302 P-606 P-605 P-604 P-603 P-602 P-601

I need to get rid of the first three digits (PL1)

I am using MS Windows 2000

Thank you,
Click to expand...

Actually, since there is a space after the PL1 you would most likely
want to remove the first 4 characters.
Exp:Mid([FieldName],5)
O-302 P-606 P-605 P-604 P-603 P-602 P-601
 
Back
Top