extracting multiple pieces of data to new fields

[Guest]

I have a table: Vendor Tech Tasks which is an export of an Outlook inbox.

I need to extract the Task ID, and Route, owner and the url to different
fields so as to make the table more user friendly. The field the data is in
Contents is rather large, and follows the general format each time.

I've tried
Right([Extract].[Contents],Len([Extract].[Contents])-InStr([Extract].[Contents],"Buisness Object: Inbox Task "))

just as a start.

This is part of what the field Contents actually looks like...

Business Object: Inbox Task IT-0108220

'Inbox Task' 'IT-0108220' has been automatically assigned to 'Group - Vendor
Tech' by the completion of 'Inbox Task' 'IT-0103935' owned by 'nldrown'.
This task is part of 'Route' 'R-0007542'
which is owned by 'jslong'




which has the following routed contentroject Space0635-179A21147092443601
GA600063181830 Vendor DrawingB00085600 Vendor DrawingB00085610 Vendor
DrawingB00085590 Vendor DrawingB00085580 CorrespondenceD1599850
CorrespondenceD1599990 Your task instructions are:
INVENSYS SYSTEMS RELEASE - CONSOLIDATION TASK 0635-179A - MAGNETIC FLOW
METERS ALL DRAWINGS / DOCUMENTS (EXCEPT CORRESPONDENCE) MUST HAVE
CONSOLIDATED COMMENT FILE This task is due on:
7/31/2007 4:32:23 PM
To find out more about the Task, use the following URL
http://plm.bwes.net/ematrix/common/emxNavigator.jsp?objectId=63818.35207.9669.48071
To find out more about the Route, use the following URL
http://plm.bwes.net/ematrix/common/emxNavigator.jsp?objectId=63818.35207.29909.2386


Is there any way to create the new fields, Task ID, Route, Route Owner and
URL in a new table while extracting the appropriate data to populate them?

Thanks - for your help

 

[Guest]

Tis me, I seem to have figured out soem of what I was doing wrong. [Extract]
in my code was causing a Parameter error....

Thanks for letting me post this & get even closer to finishing an ongoing
project...