MS Access Parsing Multiple Text From Column

Topic:MS Access Parsing Multiple Text From Column

Remainpoint:0

v0lten

PostTime:12/16/2008 11:09:03 PM

Top

Level:

Professional point:

Experience:

Thread:

276

Post:

968

Total online time:

Joined date:

4/28/2007 11:20:00 PM

Last Visit:

12/17/2008 12:36:54 AM

Status:

	Try our remote PC help service to fix your PC instantly(Only cost $19.95)
	Register to make Ads free

I have a column that has multiple text values within it.

EX:

Code:

Field7864         0     99.4%          48           0      7912       402:50:16199         0     98.5%           3           0       202        23:41:17

I would like to be able to separate each value into a separate column. After a bit of research I was able to find a parsing statement that would work for splitting up first and last names but I was unable to split up more than two values.

EX:

Code:

FirstName: Right$([Name],Len([Name])- InStr(1,[Name],",")-1)LastName: Left$([Name],InStr(1,[Name],",")-1)

Does anyone have any idea on how to successfully split up more than two values?


Ranarok	PostTime:12/16/2008 11:45:16 PM	Point:0 \| # 1
Level: 1 Professional point: 66 Experience: 1 Thread: 278 Post: 1007 Total online time: 1M Joined date: 4/28/2007 11:31:00 PM Last Visit: 12/16/2008 11:35:07 PM Status:	Hello Malacka, The query that I am developing is part of a scheduling process that I am wrapping up. The query that includes the grouped text needs to be seperated out and exported to an internal table (other columns). I already have the automatic scheduling completed, but I just needed to find a way to get the values into different columns in a table. I understand that for one time exports, the data can be toggled from exporting out of Access to a text or xls file and then re-imported/linked back into Access, but that is not what I need. It would be ideal if I can do it within a query to later append to a table. Any suggestions?

Sorry, you are not login, click here to login