How to query this?

  • Thread starter Thread starter Song Su
  • Start date Start date
S

Song Su

My field like this:

ART 201
BSICKL 020C
PHYS ED 230
CE ESL 043CE

So the first part contain upto 7 characters, followed by a space, then 3
digit number with optional 1 or 2 character.

I want my result for only first part to be like:

ART
BSICKL
PHYS ED
CE ESL

Thanks.
 
Thanks. It works perfectly.

KARL DEWEY said:
Try this --
Some_Name: Left([YourField], InStrRev([YourField], " ") -1)
--
KARL DEWEY
Build a little - Test a little


Song Su said:
My field like this:

ART 201
BSICKL 020C
PHYS ED 230
CE ESL 043CE

So the first part contain upto 7 characters, followed by a space, then 3
digit number with optional 1 or 2 character.

I want my result for only first part to be like:

ART
BSICKL
PHYS ED
CE ESL

Thanks.
Click to expand...
Click to expand...
 
Back
Top