There are about 8000 records in that table, all different, so doing it by hand is a bit much. They'd have to cart me off to a looney bin afterwards!
Lin On Sun, 13 Jan 2008 09:55:07 -0500, "MikeB" <[EMAIL PROTECTED]> said: > How many rows of data? If it is small, I would just write the names to a > text > file and massage it there to normalize it a bit with appropriate > delimiters > then load as ascii. > > If there were only a few offenders to a particular separation then by all > means > put it into another table using the string manipulation functions and > finish > the offenders by hand. Thing is, if you spend a great deal of time > trying to > figure out a way to do it programmatically for a one shot deal, sometimes > you > waste time on that instead of just doing the grunt work... > > > > > ----- Original Message ----- > From: "Lin MacDonald" <[EMAIL PROTECTED]> > To: "RBASE-L Mailing List" <[email protected]> > Sent: Sunday, January 13, 2008 9:36 AM > Subject: [RBASE-L] - pulling a text column apart > > > > Sorry, another Newbie question -- > > As I redesign my Database and application, I want to correct some > > design problems. One of them is that in my Supplier table, I > > have one column for Contacts. I'd like to move that column to > > another table with multiple fields, such as First Name, Last > > Name, etc. The problem is that the data in that field is not > > consistant. It could contain the following: > > Null > > FName > > FName LName > > FName1, FName2 > > FName1, FName2, FName3 > > So, what would be the best way to break it apart? Should I use a > > temporary table? I thought of using SSUB, but that wouldn't work > > for the ones that had a First and Last name in the field with > > just a space in between. > > thanks, > > Lin MacDonald > > > >
