| View previous topic :: View next topic |
| Author |
Message |
abrandt
General User
Joined: 05 Dec 2003
Posts: 47
Location: Fort Worth, TX
|
 Posted: Sat Aug 19, 2006 2:08 pm Post subject: ???: How to Convert Raw Database Record to Comma Delimited |
 |
|
Hello Forum Members:
 How can automate the conversion of the following ficticous RAW DATABASE RECORD (with spaces & tabs) to a clean COMMA DELIMITED record, without having to resort to doing it MANUALLY?
Dick Hxxx KIA 12xx NE 9xth St Vancouver, WA 98665 3XX0-XXX-XXXX dealership
NOTE: Spaces and tabs have been REMOVED by the forum WYSIWYG editor (can provide via email).
Thank you in advance for a prompt and detailed response.
Alan |
|
| Back to top |
|
 |
David
Super User
Joined: 24 Oct 2003
Posts: 5668
Location: Canada
|
| Posted: Sat Aug 19, 2006 3:00 pm Post subject: Re: ???: How to Convert Raw Database Record to Comma Delimi |
|
|
One problem may be whether or not you allowed fixed length for name etc. However, I'm thinking in terms of a possible approach using "CSVed", a neat little freeware CSV program. You can either look that up for yourself and consider possibilities, or PM me for a temp email address to send, and I'll see what I can perhaps do with it. You need not send the entire listing. A few records will do to see if it works.
David. |
|
| Back to top |
|
|
|
