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 > --- RBASE-L ================================================ TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [email protected] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO ================================================ TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE ================================================ TO SEARCH ARCHIVES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. ================================================
