>We have a client that wants the data (including a memo field) in comma delimited format. Is there a way to extract the contents of a memo field into an ascii record (one per line, or comma delimited)?
You could write the file using low-level file I/O a field at a time easily, enough, terminating each record's data with a CR/LF pair, but it wouldn't be a one-line command, and you may encounter problem characters (like embeded CR or LF characters in the memo field) that you'd have to handle.
Because memo fields aren't fixed length, you'd have to use some sort of delimited file. Unless you can be certain that no memo field contains a comma, you'll need to quote-encapsulate the memo field content IAC if you use a CSV-type file.
You might be better off using a hierarchical data representation like XML if the client can read XML data.