InStr() - Help with query

  • Thread starter Thread starter mralmackay
  • Start date Start date
M

mralmackay

Hi,

Is it possible to do the following @ all. I need to query a field
called DiaryEditor within table Extract for the next two words after
any occurence of the following "Updated By: ". I understand that the
InStr() function could be used but not quite sure how this is meant to
be used in this example.

TIA for your help with this.

Al.
 
Hi,

Is it possible to do the following @ all. I need to query a field
called DiaryEditor within table Extract for the next two words after
any occurence of the following "Updated By: ". I understand that the
InStr() function could be used but not quite sure how this is meant to
be used in this example.

TIA for your help with this.

Al.
Click to expand...

Assuming there are no other words after "Updated By: " something like this
should work:

Right([Extract].[DiaryEditor],len([Extract].[DiaryEditor])-instr(1,[Extract].[DiaryEditor],"Updated
By: ")-11)

Ed Metcalfe.
 
Thanks for your help with this Ed, will try this tomorrow.

Thanks, Al.

Hi,
Click to expand...
Is it possible to do the following @ all. I need to query a field
called DiaryEditor within table Extract for the next two words after
any occurence of the following "Updated By: ". I understand that the
InStr() function could be used but not quite sure how this is meant to
be used in this example.
Click to expand...
TIA for your help with this.
Click to expand...
Al.
Click to expand...

Assuming there are no other words after "Updated By: " something like this
should work:

Right([Extract].[DiaryEditor],len([Extract].[DiaryEditor])-instr(1,[Extract­].[DiaryEditor],"Updated
By: ")-11)

Ed Metcalfe.
Click to expand...
 
Back
Top