On 10/15/17 at 8:45 AM, [email protected] (jgill) wrote:
06/04/2010,DPC,"'CALL REF.NO. 0552 , TO A/C
03520000",300.00,130117.86,"'Gxxxx J & M","'504237-00001424",
As I read that line, the separated columns are:
06/04/2010
DPC
"'CALL REF.NO. 0552 , TO A/C 03520000"
"'Gxxxx J & M"
"'504237-00001424"
Normally, .csv files quote data to eliminate ambiguity as to the
column separators, etc.
Your bank's system seems to be doing this with an extra single
quote (') after the opening double quote.
So you *might* be able to do a search & replace: find all cases
of "' and replace with " (that's find single-quote double-quote,
replace with just a double-quote). Then see whether Numbers will
open the file correctly.
HTH
--
- Bruce
_bruce__van_allen__santa_cruz__ca_
--
This is the BBEdit Talk public discussion group. If you have a
feature request or would like to report a problem, please email
"[email protected]" rather than posting to the group.
Follow @bbedit on Twitter: <http://www.twitter.com/bbedit>
---
You received this message because you are subscribed to the Google Groups "BBEdit Talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/bbedit.
