-! Copyright (C) 2007, 2008 Phil Dawes
+! Copyright (C) 2007, 2008 Phil Dawes, 2013 John Benediktsson
! See http://factorcode.org/license.txt for BSD license.
-USING: combinators fry io io.files io.streams.string kernel
-make math memoize namespaces sbufs sequences sequences.private
-unicode.categories ;
+USING: combinators io io.files io.streams.string kernel make
+math namespaces sequences sequences.private unicode ;
IN: csv
SYMBOL: delimiter
<PRIVATE
-MEMO: field-delimiters ( delimiter -- field-end quoted-field )
- [ "\n" swap suffix ] [ "\"\n" swap suffix ] bi ; inline
+MEMO: field-delimiters ( delimiter -- field-seps quote-seps )
+ [ "\r\n" swap prefix ] [ "\r\"\n" swap prefix ] bi ; inline
-DEFER: quoted-field
+DEFER: quoted-field,
-: maybe-escaped-quote ( delimeter stream quoted? -- delimiter stream endchar/f )
- 2over stream-read1 swap over =
+: maybe-escaped-quote ( delimeter stream quoted? -- delimiter stream sep/f )
+ 2over stream-read1 tuck =
[ nip ] [
{
- { CHAR: " [ [ CHAR: " , ] when quoted-field ] }
- { CHAR: \n [ ] } ! Error: newline inside string?
+ { CHAR: \" [ [ CHAR: \" , ] when quoted-field, ] }
+ { CHAR: \n [ ] } ! Error: cr inside string?
+ { CHAR: \r [ ] } ! Error: lf inside string?
[ [ , drop f maybe-escaped-quote ] when* ]
} case
] if ; inline recursive
-: quoted-field ( delimiter stream -- delimiter stream endchar/f )
+: quoted-field, ( delimiter stream -- delimiter stream sep/f )
"\"" over stream-read-until drop % t maybe-escaped-quote ;
+: quoted-field ( delimiter stream -- sep/f field )
+ [ quoted-field, 2nip ] "" make ;
+
: ?trim ( string -- string' )
dup length [ drop "" ] [
- over first-unsafe blank?
- [ drop t ] [ 1 - over nth-unsafe blank? ] if
- [ [ blank? ] trim ] when
+ over first-unsafe unicode:blank?
+ [ drop t ] [ 1 - over nth-unsafe unicode:blank? ] if
+ [ [ unicode:blank? ] trim ] when
] if-zero ; inline
-: field ( delimiter stream field-end quoted-field -- delimiter sep/f field )
- pick stream-read-until dup CHAR: " = [
- drop
- [ drop [ quoted-field nip ] "" make ]
- [
- swap rot stream-read-until
- [ "\"" glue ] dip swap ?trim
- ]
- if-empty
- ] [ [ 2drop ] 2dip swap ?trim ] if ;
+: continue-field ( delimiter stream field-seps seq -- sep/f field )
+ swap rot stream-read-until [ "\"" glue ] dip
+ swap ?trim nipd ; inline
+
+: field ( delimiter stream field-seps quote-seps -- sep/f field )
+ pick stream-read-until dup CHAR: \" = [
+ drop [ drop quoted-field ] [ continue-field ] if-empty
+ ] [ 3nipd swap ?trim ] if ;
-: (stream-read-row) ( delimiter stream field-end quoted-field -- delimiter sep/f fields )
- [ dup [ 2dup = ] ] 3dip '[ drop _ _ _ field ] produce ;
+: (stream-read-row) ( delimiter stream field-end quoted-field -- sep/f fields )
+ [ [ dup '[ dup _ = ] ] keep ] 3dip
+ '[ drop _ _ _ _ field ] produce ; inline
: (stream-read-csv) ( stream -- )
- delimiter get
[ dup [ empty? ] all? [ drop ] [ , ] if ]
- rot pick field-delimiters
- '[ _ _ _ (stream-read-row) ] do while drop ;
+ delimiter get rot over field-delimiters
+ '[ _ _ _ _ (stream-read-row) ] do while ;
PRIVATE>
: stream-read-row ( stream -- row )
- delimiter get swap over field-delimiters
- (stream-read-row) 2nip ; inline
+ delimiter get tuck field-delimiters
+ (stream-read-row) nip ; inline
: read-row ( -- row )
input-stream get stream-read-row ; inline
: stream-read-csv ( stream -- rows )
[ (stream-read-csv) ] { } make
- dup last { "" } = [ but-last ] when ; inline
+ dup ?last { "" } = [ but-last ] when ; inline
: read-csv ( -- rows )
input-stream get stream-read-csv ; inline
<PRIVATE
: needs-escaping? ( cell delimiter -- ? )
- '[ dup "\n\"" member? [ drop t ] [ _ = ] if ] any? ; inline
+ '[ dup "\n\"\r" member? [ drop t ] [ _ = ] if ] any? ; inline
: escape-quotes ( cell stream -- )
- CHAR: " over stream-write1 swap [
+ CHAR: \" over stream-write1 swap [
[ over stream-write1 ]
- [ dup CHAR: " = [ over stream-write1 ] [ drop ] if ] bi
- ] each CHAR: " swap stream-write1 ; inline
+ [ dup CHAR: \" = [ over stream-write1 ] [ drop ] if ] bi
+ ] each CHAR: \" swap stream-write1 ;
: escape-if-required ( cell delimiter stream -- )
[ dupd needs-escaping? ] dip