The double quote, CHR(34), is used as a delimited for strings as in "First name", "Last Name", "etcetera" and should probably be removed/ replaced on output and fixed again on input to avoid applications that have a hard time parsing this.
I often use STRTRAN() to change it to a less-likely used character like tilde ~ or backtick ` On Wed, Dec 23, 2015 at 2:50 PM, M Jarvis <[email protected]> wrote: > On Wed, Dec 23, 2015 at 11:35 AM, Sytze de Boer <[email protected]> > wrote: > >> In my system, clients can upload/update their inventory by importing from a >> CSV file. >> >> Suddenly, a client has reported a problem and I have noticed the following. >> >> 1 When he imports from a CSV file, all references to "inch" which is noted >> as " in the column, automatically becomes '"' >> 2 If I import the file as a TXT file instead, it leaves out the " >> altogether >> >> I guess there's a workaround but is there something else I should check >> >> -- >> Kind regards, >> Sytze de Boer >> >> > Does this happen on ALL computers at the client site? If not, then maybe > check out settings such as UNICODE (or whatever) and see what's been > changed.... > > -- > Matt Jarvis > Eugene, Oregon USA > > > --- StripMime Report -- processed MIME parts --- > multipart/alternative > text/plain (text body -- kept) > text/html > --- > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cacw6n4ugtrejbbfycx3kisrncxlvuhjzktefr8zxu7ykt1s...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
