[AccessD] How to separate data of one field

Kath Pelletti KP at sdsonline.net
Sun May 29 19:29:00 CDT 2005


Kostas - will your database continue to need to parse the data or is it a one off? I was just thinking that if it is a one off then you could put it in Excel and given that you have commas as delimiters, the Excel 'Tools, Text to Columns' wizard is very good.

If the function needs to be ongoing though then you'll need to code it...

Kath
  ----- Original Message ----- 
  From: Kostas Konstantinidis 
  To: Access Developers discussion and problem solving 
  Sent: Sunday, May 29, 2005 1:06 AM
  Subject: [AccessD] How to separate data of one field 


  dear group...
  I have two questions:

  1) Into a field I keep names and in many cases there are two or either three 
  names into the same field e.g.
  George Papas, John Stevenson, Jack Bolt
  what I want to do is to separate that field into two or three depenting by 
  the "comma" like
  George Pappas
  John Srevenson
  Jack Bolt

  2) How is possible to appear first the Last name instead of the First name
  First name, Last Name
  to Last Name, First Name

  thank's a lot
  /kostas 


  -- 
  AccessD mailing list
  AccessD at databaseadvisors.com
  http://databaseadvisors.com/mailman/listinfo/accessd
  Website: http://www.databaseadvisors.com
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list