Recent content by des0929

What function would I use to take a string and parse it the following way: Original string: 20BPP0355 1. Need to find the "BPP" and bring every value to the right of "BPP" into a new field: New string: 0355

One more question: How about parsing this one: Field value: View Bid History INPUT:In the Process Bid invitations screen, click on the History hyperlink. INPUT: value is always constant. I need the "View Bid History" string. Thanks again!

Does anyone know the MS Access query sytax for an in list condition FoxPro example: Select * from table where inlist('Tom','Mary') Thanks.

I'm trying to ODBC connect MS Access to my Oracle database. I have problems with tables that have CLOB format fields. How can I get around this problem? Can a view be created that can change the datatype of the CLOB field(s) into a VARCHAR format? If so, how is this done...Oracle function...

Thanks for your help Mike and your quick reply.Your suggestion worked great!...if you have a moment, can you take a look at one more related question. The only difference is that I would need to parse out three values from this one string. How would I write the expression to bring back the...

I have a description field --DESCR--in Access. The field is the result of the concatenation of 3 fields in another application. I would like to split this DESCR field. Here is an example: DESCR ---------------------------------- SCENARIO: Regional Reimbursable Commodity SCRIPT: REM1000 The...