@Taewoo: can you send me the syntax or the documentation URL to show the syntax?
Chen On Sat, Jul 25, 2015 at 3:27 PM, Taewoo Kim <[email protected]> wrote: > Can you try to load it into an internal dataset? I think I have implemented > the "comma between the comma (delimiter)" when modifying the delimited data > parser. And Chris also modified that part, too. If it doesn't work, I can > look at the issue. > > Best, > Taewoo > > On Sat, Jul 25, 2015 at 1:51 PM, Chen Li <[email protected]> wrote: > >> Not sure if this topic was discussed before. I was trying to load an >> external CVS file using "," as the delimiter. But the engine failed to >> read a file with the following single record: >> >> 14, "John Smith, Mary Reeve" >> >> >> use dataverse pubs; >> >> create type PaperType as open { >> id: int32, >> authors: string >> } >> >> create external dataset Papers(PaperType) >> using localfs >> (("path"="127.0.01:///Users/chenli/tmp/asterix-data/papers.csv"), >> ("format"="delimited-text"), >> ("delimiter"=",")); >> >> for $paper in dataset('Papers') >> return $paper; >> >> The following is the output, which shows that the comma in the authors >> field was incorrectly used to break the field. Any idea about how to fix >> it? >> >> Output >> Results: >> >> { "id": 14, "authors": " \"John Smith" } >> >> Duration of all jobs: 0.091 sec >> >> Success: Query Complete >>
