It depends on how you export, of course. UNLOAD DATA AS CSV or ASCII always encloses in double quotes – not sure how it uses the QUOTE setting. For GATEWAY EXPORT CSV you specify qualifier and separator characters.
Excel (save as csv) behaves perfectly for me although I don’t know how to change the qualifier and separator characters. Regards, Stephen Markson The Pharmacy Examining Board of Canada 416.979.2431 x251 From: karentellef via RBASE-L [mailto:[email protected]] Sent: December-22-16 11:38 AM To: [email protected] Subject: Re: [RBASE-L] - Re: From The Edge: Optimizing R:BASE Cloud Applications I agree, Stephen. I have lots of situations of column data that contains a comma, such as descriptions of items or full names that might contain a comma (like Smith, Jr). RBase behaves nicely in that it always encloses text fields with quotations on export. Now, Excel doesn't behave as nicely if you try to export from it. But I've never had anything complain importing from RBase because it puts the quotation marks. Karen -----Original Message----- From: Stephen Markson <[email protected]<mailto:[email protected]>> To: rbase-l <[email protected]<mailto:[email protected]>> Sent: Thu, Dec 22, 2016 10:21 am Subject: RE: [RBASE-L] - Re: From The Edge: Optimizing R:BASE Cloud Applications We import and export text with embedded commas all the time. There is absolutely no problem as long as you set it up correctly. Regards, Stephen Markson The Pharmacy Examining Board of Canada 416.979.2431 x251 From: [email protected]<mailto:[email protected]> [mailto:[email protected]<mailto:[email protected]?>] On Behalf Of Michael Byerley Sent: December-22-16 10:43 AM To: RBASE-L Cc: [email protected]<mailto:[email protected]> Subject: [RBASE-L] - Re: From The Edge: Optimizing R:BASE Cloud Applications I would argue strongly against storing a comma separated list directly in a text (or any textual based) column. it wreaks havoc on import/exports. You should employ a conversion to something handy, like the # symbol or such before storing as it's not much of a trick to wind and unwind it in runtime On Wednesday, December 21, 2016 at 10:00:01 AM UTC-5, A. Razzak Memon wrote: Wednesday, December 21, 2016 From The Edge.: Optimizing R:BASE Cloud Applications Product.......: R:BASE X, R:BASE X Enterprise (Version 10) Build.........: 10.0.2.11130 or higher www.rupdates.com<http://www.rupdates.com> Section ......: Multi-User Environment Considerations Environment...: Microsoft Windows Server 2012R2 The ability to fine tune R:BASE itself is one of the many enhancements added over the years. Most often, R:BASE is able to make the right decisions about the best way to process commands. Generally, you know your database and application code better than anyone else. However, you should always take advantage of the latest enhancements and syntax, and pick the most efficient method if given the opportunity. Did you know that there are four settings that can improve performance in a multi-user environment with Cloud applications? . STATICDB . ROWLOCKS . FASTLOCK . PAGELOCK A technical document on Optimizing R:BASE Cloud Applications is now available. From The Edge: http://www.razzak.com/fte Article Title: Managing User Privileges in R:BASE X/XE (Version 10) Have fun! Very Best R:egards, Razzak. www.rbase.com<http://www.rbase.com> www.facebook.com/rbase<http://www.facebook.com/rbase> -- 33 years of continuous innovation! 18 Years of R:BASE Technologies, Inc. making R:BASE what it is today! -- -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
