Edward S Zuris
edzedz at comcast.net
Tue May 6 10:56:16 CDT 2008
Can you ask the spreadsheet program to use a different delimiter than a space. In Excel you can ask for a tab, and that seems to work. If it is some other spreadsheet such as Lotus, there should be other export options than space delimited. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Charlotte Foust Sent: Tuesday, May 06, 2008 7:41 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Normalizing a text field Well, actually there is a delimiter, a space, it just isn't reliable because there can be spaces in both the city name and the state name as well. Charlotte Foust -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: Tuesday, May 06, 2008 5:28 AM To: Access Developers discussion and problem solving; Dba-Sqlserver Subject: [AccessD] Normalizing a text field I have a spreadsheet with a zip column and a column with 0 to many cities in the format Name1, St Name2, St Name3, St Notice that there is no "field delimiter" between St (state) and the next city name. Is there any way in SQL to do this or is this a job for code? I can write the code, but I am lost on doing this in SQL. -- John W. Colby www.ColbyConsulting.com -- 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