Can anybody help with extracting memo field information in preperation to exp[ort to Excel.
I ran a structured query using several tables and got my answer. Included are several memo fields that detail out findings, conclusions, etc. for a record. However, our analysts does not use paradox and needs the data in Excel.
I am aware that an Excel cell will most likely trim the memo field to say 256, but thats OK.
I prefer to not use object code as our system is locked down to prevent data corruption with spurious code. Mike P., I am sure you are aware of our data issues working with Dan.
If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html,
social networking links, message board signature, company profile, etc.
If it's really OK that the memo be trimmed to a 256 character string, you could create a table with the same key field[s] as the one you want to export plus an A255 field (let's call it EXPMEMO.DB and the field ExpMemo). Open tCursors on both tables - tcMain and tcExp; place tcExp in edit mode.
Then do a tCursor scan through the main table, and at each record insert a record in tcExp, assign the key values from tcMain, cast the memo value from tcMain as a string, take the substr(1,255) of that string, and asssign THAT to tcEx."ExpMemo".
Now run a query to join the two tables, leaving out the memo field and including the ExpMemo field. Export the query result to Excel.
Just crude and off the top of the head, but it ought to work. And if the export candidate is able to fit in Excel, it can't be too time consuming.
Steve Caple Programmer Analyst Prestwood Software http://www.prestwood.com
Member subscribes to this thread with a verified email.
Old Account!
If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html,
social networking links, message board signature, company profile, etc.