Another parcing question

Hello all,

I am provided a CSV txt file from an Oracle DBS. I import it into Access so I can perform reports and other actions. (Don't ask why).

One of the txt fields has the following 'type' of information

"User: Wilson Frederick opened Facility: RM101 at 8/2/2003 05:44:11"

what I want to do is have "Wilson Frederick" in a column and "RM101" in a column.

I think the priciple is to find everything between "User: " and " opened". As well as everything between "Facility: " and " at".

I found this one the net
http://www.mvps.org/access/strings/str0003.htm

I think that article is going down a similar road but I am not sure how to apply it to my situation.

Any ideas?

Thanks,
--
Frederick Wilson

_____________________________________
for multimedia design services visit
http://www.legalanimatics.com
.

Relevant Pages

  • exporting to CSV
    ... Some people instead of reports want Comma Seperated Files. ... trying to find a good way of outputting to csv with using either sql ... I used bcp using the master.dbo.xp_cmdshell command to output the ... The problem with that is that the bcp executes the stored proc ...
    (comp.databases.ms-sqlserver)
  • Automatic log on to website and download report using VBA
    ... I have to pull out some reports from my company's intranet web-site (a ... reporting system) in CSV format on a regular basis and this CSV file is ...
    (microsoft.public.excel.programming)
  • How to use ruby, csv and webservice? Need a direction.
    ... I have an app that does inventory and I also created a bunch of reports ... All of my reports can produce: xls, csv, pdf ... I can have a copy of my app running on my scheduling computer that I ...
    (comp.lang.ruby)
  • Re: Automatic log on to website and download report using VBA
    ... I have to pull out some reports from my company's intranet web-site (a ... reporting system) in CSV format on a regular basis and this CSV file is ...
    (microsoft.public.excel.programming)