By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,294 Members | 2,687 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,294 IT Pros & Developers. It's quick & easy.

delete all suffix automatically

P: n/a
O
I have a field containing thousand of vehicle number plates like these:

SBP3432D
SCX845T
EP2X
QM45G
S1P

how can I delete all the suffix at one go so that the result will be:

SBP3432
SCX845
EP2
QM45
S1

Any help will be appreciated.

Mike
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On Fri, 2 Apr 2004 12:40:34 +0800, O wrote:
I have a field containing thousand of vehicle number plates like these:

SBP3432D
SCX845T
EP2X
QM45G
S1P

how can I delete all the suffix at one go so that the result will be:

SBP3432
SCX845
EP2
QM45
S1

Any help will be appreciated.

Mike


If it's always just the last 1 character to be dropped:
[SomeField] = Left([FieldName],Len([FieldName])-1)
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
Nov 12 '05 #2

P: n/a
Thanks Fred,

I've done it!

Mike

"fredg" <fg******@example.invalid> wrote in message
news:1i*******************************@40tude.net. ..
On Fri, 2 Apr 2004 12:40:34 +0800, O wrote:
I have a field containing thousand of vehicle number plates like these:

SBP3432D
SCX845T
EP2X
QM45G
S1P

how can I delete all the suffix at one go so that the result will be:

SBP3432
SCX845
EP2
QM45
S1

Any help will be appreciated.

Mike


If it's always just the last 1 character to be dropped:
[SomeField] = Left([FieldName],Len([FieldName])-1)
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.