extracting text out of a column

  • Thread starter Thread starter Mandy J.S.
  • Start date Start date
M

Mandy J.S.

This table is linked to another database. I have one column that contains
data that starts out with the job number. I want to make another column in a
query that shows just the job number. It is formatted as so: "06-0207 -
update progress" and I want to have another column that contains only the
06-0207 part. Here is what I had done in Excel: LEFT(B2,FIND(" ",B2)).
However, I don't want to use Excel. Any ideas? Thanks.

Mandy Jo
 
You can use the function Left with the function InStr that will find the
location of the space between the number and the description

Something like

Left([FieldName],Instr([FieldName]," ")-1)
 
That worked fabulously. Thank you!!!!

Mandy Jo

Ofer Cohen said:
You can use the function Left with the function InStr that will find the
location of the space between the number and the description

Something like

Left([FieldName],Instr([FieldName]," ")-1)


--
Good Luck
BS"D


Mandy J.S. said:
This table is linked to another database. I have one column that contains
data that starts out with the job number. I want to make another column in a
query that shows just the job number. It is formatted as so: "06-0207 -
update progress" and I want to have another column that contains only the
06-0207 part. Here is what I had done in Excel: LEFT(B2,FIND(" ",B2)).
However, I don't want to use Excel. Any ideas? Thanks.

Mandy Jo
Click to expand...
Click to expand...
 
Back
Top