Razzak, Thanks for your suggestion. I tried that but I still have all of the RTF codes in the NOTE column. Was the expectation that these would be removed ? (Or have I missed the point here ?)
Thank you. Regards, John Docherty -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of A. Razzak Memon Sent: Thursday, 4 April 2013 7:52 a.m. To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Exporting VARCHAR fieldscontainingformatted text At 02:33 PM 4/3/2013, John Docherty wrote: >Razzak, > >Thanks Razzak - yes, please let me know what I need to do. John, You can easily convert the VARCHAR data to NOTE data! Try the exercise below to get an idea. Example: TableA: ColumnA INTEGER ColumnB VARCHAR TableB: ColumnA INTEGER ColumnC NOTE Routine to convert VARCHAR to NOTE Field: INSERT INTO TableB (ColumnA, ColumnC) SELECT ColumnA, ColumnB FROM TableA The resulting ColumnC in TableB will include the converted VARCHAR to NOTE. That's all there is to it! In your specific case, you can accomplish the task using TEMPORARY tables. Once you have the required data as NOTE column, you can use the power of UNLOAD or GATEWAY EXPORT options to extract data, on demand. Very Best R:egards, Razzak. www.rbase.com www.facebook.com/rbase --- RBASE-L =======================3D=======================3 D= 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) =======================3D=======================3 D= TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO =======================3D=======================3 D= TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE =======================3D=======================3 D= 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. =======================3D=======================3 D=
