Find Text Between { and }

eao · Sep 28, 2005

So I need to write a query to extract the value between two braces { }. Using the subject line as an example, I want to return the value " and ". I know how I'd do this in SQL, but I can't figure out the equivalent substr function in Jet SQL.

Golom · Sep 28, 2005

Try

Code:

Mid (TheString, Instr(TheString, "{")+1, _ 
                Instr(TheString, "}") - Instr(TheString,"{") - 1)

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Find Text Between { and }

eao

MIS

Golom

Programmer

Similar threads

Part and Inventory Search

Sponsor