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