extract text between asterisks

  • Thread starter Thread starter Springman
  • Start date Start date
S

Springman

I have a records like the following and would like to extract the text
between asterisks

*ANALGESICS - ANTI-INFLAMMATORY*

Thank you for your assistance!
 
Springman said:
I have a records like the following and would like to extract the text
between asterisks

*ANALGESICS - ANTI-INFLAMMATORY*

Thank you for your assistance!
Click to expand...


SELECT tblTest.testtext,
Left$(Mid$([testtext],InStr(1,[testtext],"*")+1),InStr(1,Mid$([testtext],InStr(1,[testtext],"*")+1),"*")-1)
AS Expr1
FROM tblTest
WHERE ((InStr(1,[testtext],"*")<>0));

Replace "tblTest" with the name of your table, and "testtext" with the name
of your field.

In query design view, the expression looks like this ...

Expr1:
Left$(Mid$([testtext],InStr(1,[testtext],"*")+1),InStr(1,Mid$([testtext],InStr(1,[testtext],"*")+1),"*")-1)
 
Back
Top